If then statements with date fields
so_tx_anglerette
✭✭✭
Hello. I am trying to calculate a date field based on the following manually entered data:
- If "Project status" is not "Cancelled" [drop down field]
- And "Const duration" is not null [text/number field]
- Then add "Const duration" to "Start date" to equal "Completion date"
- For example:
- Start date is 6/21/18 & duration is 2 days = 6/22/18 Completion date
*Note: First day is counted
Any help appreciated.
Tags:
Comments
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K 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