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.

Calculate due date based on start date + either 1 or 5 days

I need to calculate a investigation date which would be 5 days, unless the "foodborne Illness" cell is checked, inwhich case the investigation date is 1 day after the complaint date.


This is for a complaint log I am putting together. I want to auto populate the deadline for the inspector to initiate the investigation.


I also need to calculate a deadline for turning in the report which would be 10 days from the complaint date


Thank you


This discussion has been closed.