-
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
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", "")
-
How to add "Reasons Why" to the Decline action of a Approval Workflow
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"?
-
One Data Set, Multiple Calendars
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…
-
Best Practices for Employee HR Dashboards
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…
-
Options to display all formulas/functions in a sheet
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.…
-
MM/DD/YYYY Date Format
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.
-
Sum, Count and maybe IF statement.
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,…
-
Data Shuttle Synch Capability
Hello - I need to set up a sheet based on an employee roster that will be updated quarterly. I'd like to use a Data Shuttle upload workflow to attach the updated roster to the sheet and have it automatically remove termed employees and add new rows for those that are new hires, without deleting the existing rows in the…
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
-
9-box talent assessment
I have googled and cannot find any company that has automated the 9-box talent assessment outside of excel. I feel like this is a huge miss as all large corporations do talent reviews and succession planning. What would be really cool is if you had all your HR data in Smartsheet and you could have a visual of each team on…