I can't seem to get the following formula to work in my smartsheet - it is referencing a column with dates in it:
What am I doing wrong? When I type it in, it just treats the syntax as text.
At first I would check if your formula is in a Date type column.
In which column are you trying to add the formula?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Yes, I'm trying to use the formula in a Date type column. How does that impact the formula?
Update: I think I figured out the problem. I hadn't used this smartsheet in awhile. The 'start' column in which I was trying to put the formula had dependency settings that referenced a 'predecessor' column (which I had not updated) which is supposed to list the previous row and a 'duration' column which calculates the number of days between the previous row's start and due date.
Thank you for the previous answers!
Happy to help!
Glad you got it working!
Apologies if this has been previously discussed or in support already. Is there a way to get smartsheet to send an email notification in say 1 month based on the date entered in the cell? i.e. Went to a building site on the below date... smartsheet automatically sends me an email reminder in 1 month from this date to alert…
Hello, I am currently attempting to organize my files in Workspace by creating folders to group them. I am doing this by dragging and dropping sheets from the 'Sheets' folder into my 'Workspace' folder. However, some sheets that I own and created do not appear in the 'Sheets' folder. I even tried editing some details in my…
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.