Variance formula between Baseline End Date vs Today vs Actual End Date
Hi Community,
How to get only 1 formula for combining :
If Today >= Baseline End Day = positive days behind schedule, if not "0"
If Task "Completed", showing the variance between Actual and Baseline End date
Thank you
Answers
-
Could we get a screenshot of what it is your working with. Be sure to clean it of any sensitive information.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
How to get only 1 formula in column 'Behind schedule/Potential impact on delivery' showing the variance between Baseline End date vs Actual end date only if Actual date = >Today , if not showing "0'
And in the meantime how to STOP the countdown as soon as the status of the task is triggered as "Completed', but still showing the days behind schedule, if any.
Thank you
-
Hi @Mark.poole
Is there any formula that can fit our need in this case?
Thank you
-
Any Input on this one?
I haven't gotten this deep into Smartsheet yet so i am not sure how to answer.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
You would use an IF statement as the base and write it out to follow the original post logic in reverse order.
If the status is completed, variance between end dates, otherwise the maximum of either zero or variance between today and baseline end.
=IF(Status@row = "Completed", [Actual End Date]@row - [Baseline End Date]@row, MAX(0, TODAY() - [Baseline End Date]@row)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Fantastic ! It works !
Thank you
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!