Tracking Date versions
I have one problem statement. Please provide your idea/solution in the below example
Problem Statement: We have columns set up to track the dates when version 1 is submitted, version 2 is submitted, version 3 is submitted…. Etc.
We want a column that says “Two Week + Flag” in front of the columns tracking all the versions, so that they can create a report and follow up with their vendors because two weeks have gone by and they have not yet received an update.
We want to track WORK DAYS only and then want the column to read “yes” only when 9 days have gone by and a new version was not recorded.
Example:
Version 1 was submitted on 10/25/22 and version 2 was submitted 11/1. There would be NO “yes” in the column. But say version 3 column is empty, the “Two Week + Flag” column should read “YES” on 11/14 until the Version 3 date is filled in (that is less than or equal to 9 days from the previous version).
Now the even bigger challenge. Let’s say it says “YES” and then they follow up and receive the new version… They need that column to NO LONGER say “yes” until the next version exceeds the “yes”
Thanks & Regards
Email ID: info@sspmconsultants.com
Did I answer to your question or fix the problem? Please help
the Smartsheet Community
by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!
Answers
-
@Khasim I would suggest using a MAX function to pull in the most recent date across the columns. You can then nest that in a NETWORKDAYS function with TODAY being the "end date" to find out how far in the past the most recent version was received. From there you would build an IF statement around it saying that if the NETWORKDAYS output is more than whatever number then output "yes".
-
Thanks @Paul Newcome. Let me try that.
Thanks & Regards
Email ID: info@sspmconsultants.com
Did I answer to your question or fix the problem? Please
help
theSmartsheet Community
by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!