Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Help with date formula

edited 12/09/19 in Archived 2017 Posts

Need formula to calculate a date:

Spreadsheet has (3) Columns as follows:

Cal Type (drop down) with 2 options - In-house or Third-Party

Next Cal Date:  Date

Reminder Date: Date

Would like formula to calculate the following If/then scenario:

If value in Cal Type is "Third Party" then need Reminder Date to be Next Cal Date - 30 days.


Thanks for your assistance



This discussion has been closed.