Calculating Date Range Based on Status Change
![Amber Jackson](https://us.v-cdn.net/6031209/uploads/avatarstock/n7ZG0TBD44T33.png)
Hi there gurus!
I need help creating a formula to calculate a date range. I know I need to subtract two dates; that's the easy part. The difficulty I'm facing is automating my second date. Is there a way to have Smartsheet automatically enter the date that a status changes to a particular value in the dropdown menu? I need to know the date that a status box was changed from "in testing" to "in review". That will give me the second date I need for my calculated range.
Any ideas?
Best Answer
-
You can use the new Record a date feature.
More info.
Would that work/help?
I hope that helps!
Have a fantastic day & Happy New Year!
Best,
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
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hello Amber,
Off the top of my head, I know there is a Modified (Date) system column type that will create a time stamp when a row is modified. Have you tried this?
https://help.smartsheet.com/articles/1964567-system-columns
You could then lock rocks when they are changed, to avoid this date being updated again in the future. If you need to repeatedly keep track of status changes for one row item, this may get tricky. You might have to play around with moving rows to different sheets, or copying modified dates to different columns based on what the status box value is.
Rachelle
-
You can use the new Record a date feature.
More info.
Would that work/help?
I hope that helps!
Have a fantastic day & Happy New Year!
Best,
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
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå that worked beautifully! Thank you so much for the help!!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62K Get Help
- 348 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 132 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!