Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
What formula do I use
For "When start date is populated, auto turn Status to ‘in progress’
Im new to Smartsheet and ProDesk appointments are not available until June 2nd. Any guidance is appreciated, thank you!
Answers
-
You should get what you need if you put that in your status column and make it a column formula
=IF(ISBLANK([Start Date]@row), "Not Started", "In Progress")
-
-
It might be to basic of a solution but assuming your statuses are, Not Started, In Progress and Completed, I would maybe try something like:
=IF([Target End Date]@row ="", "Completed", IF([Target Start Date]@row ="", "Not Started", IF([Target Start Date]@row <>"", "In Progress")))
This might need some maniputlation, but I think it all looks right!
Good luck!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 468 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I saw someone else asked the same question in another thread https://community.smartsheet.com/discussion/108384/including-a-comma-for-currency-within-an-existing-formula but the answer was very confus…
- I need this formula to return the pay date {pay date} if the hire date [Hire/QE Date]@row is between the date range for the beginning of the pay period {Begin Date} to the end of the pay period {End D…
- I am trying to sum a column {Invoice Amount} when the {Month Paid} in that row is misspelled. I have accounted for each month of the year as well as if the cell is blank. I want to sum everything else…