If then statements with date fields

edited 12/09/19 in Smartsheet Basics

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.