Using IF
Can you please suggest what is wrong with this formula? (Priority Level and Modified are both columns. Priority Level is a dropdown, Modified is the automated modified date.
=IF([Priority Level]@row, ="High: Within 2 business days", (Modified)@row)
I am eventually trying to get the formula to add 2 days to the modified date if level is high, 5 days if "Medium," etc. Thank you!
Best Answer
-
An extra comma and some extra parens:
=IF([Priority Level]@row ="High: Within 2 business days", Modified@row)
If the actual name of the Modified column DOES have the open and close parens, you will need to enclose it in square braces. [(Modified)]@row
Answers
-
An extra comma and some extra parens:
=IF([Priority Level]@row ="High: Within 2 business days", Modified@row)
If the actual name of the Modified column DOES have the open and close parens, you will need to enclose it in square braces. [(Modified)]@row
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives