Hi there, I am creating a new employee onboarding spreadsheet to assist our new hires in getting familiar with the company and have come across a roadblock. I want this spreadsheet to be reusable for different employees as they start in a department. I want it to function similar to this link at the bottom where it creates…
This discussion has been merged.
Has anyone made an org chart in Smartsheets?
The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")
I am working on a an extensive approval workflow with numerous steps and approvers. I am running into a challenge with getting the reasons why someone is declining a request to be part of the automation. Is there a way to allow for the user to input comments to support their reasoning for hitting "Decline"?
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
Hi - I am trying to create a dashboard for each employee in our company that contains their personal HR data (such as time off balances). I've created several reports that I would like to share with each user on a dashboard. Normally, I would utilize the "current user" feature and create one report for each element, one…
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
Can we please add a MM/DD/YYYY date format to Smartsheet? I would like to feed this date into some DocuSign forms I need employees to complete, but they require a MM/DD/YYYY format in order for me to be able to utilize these dates.
Hello All, I’m needing help with creating a formula that seems a bit complex to me. I think it’s really a two-part formula or more. My data will span across two different sheets. My first sheet (Accepted Job) will have data where team members have accepted a Job on a new shift. The important data from this sheet is area,…