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