create a due date based on report date and category
looking for a formula to do the following:
Target due date based on category:
Due date is report date, status is OPEN +number of days based on risk category
High - report date +1 day
Medium - report date +3 days
Low - report date + 7 days
Advisor - report date + 10 days
then place the target due date in the column
TYIA
Answers
-
This formula should do what you need
=IF([Risk Category]@row = "Low", [Date of Audit]@row + 7, IF([Risk Category]@row = "Medium", [Date of Audit]@row + 3, IF([Risk Category]@row = "High", [Date of Audit]@row + 1, IF([Risk Category]@row = "Advisor", [Date of Audit]@row + 10, [Date of Audit]@row))))
Tested and working as below.
Hope this helps
Thanks
Paul
-
Sorry for the delay - had been traveling.
I used the formula and it comes in a little weird.
date of audit was 9/14 and the category was "low" and came back as below.
I seems to add the 1, 3, 7, 10 to the end of the date. Not sure what I'm missing.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!