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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 151 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives