Formula Assistance for Returning a Due Date
Hello,
I feel like I'm almost there on the formula, but can't figure out why WORKDAY is causing a #unparseable error.
Function of the formula: If urgent flag is marked on the row I want the due date to be due on the same date that was by the 'Date Created' column type.
If the flag is not marked, I want the formula to calculate the due date to be due in 2 days from when the Date Created field was generated.
Here is my current formula:
=IF(URGENT@row=1,Created@row,Created@row+WORKDAY(Created@row,2,)
I can make the formula work with just Created@row +2 as part of the false statement, but I would prefer the due date not to land on a weekend.
Thanks for reading and the assistance!
Tags:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!