Due date based on the start date and task schedule
System
Employee
This discussion was created from comments split from: Date formula based on frequency.
Answers
-
I have a sheet and need to create a due date that based on the start date and calculates based on the task schedule. options in the task schedule are
Adhoc Request
Upon Request
Daily
Weekly
Monthly
Bi-Monthly
BI-Weekly
2 Times Per Week
2 Times Per Month
3rd Business Day of Month
Last Monday of Month
Last Tuesday of Month
Last Wednesday of Month
Last Thursday of Month
Last Friday of Month
EOM
EOW
Quarterly
Semi-Annual
AnnualI tried modifying the formula you suggested and keep getting a circular error. Any help would be greatly appreciated.
-
Exactly what is your formula and where are you putting it?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 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!