Issue with If Statement
Not sure if it is possible, I have tried some basic if statements but not getting anywhere.
Looking for some help please, trying to get an if statement to work in the Validation Status column, where if the due date is over 7 days the status column is populated with 'overdue', or if the due date is within 30 days then the status column is populated with 'close to due date' or the status column is populated with complete' when a date is entered into the date documentation submitted on teams column.
Answers
-
Hi @DRuscitti
I assume you are expecting a status to appear when the due date is in the next 7 days to be overdue and when it is in the next 30 days to say close to due date. If that is the case, you can use this formula
=IF([Date Document Submitted on Teams]@row <>"", "Complete", IF([Due Date]@row < TODAY(7), 'Overdue", IF([Due Date]@row <= TODAY(30), "Close to due date")))
The column will remain blank in this case, if the due date is over 30 days from today.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!