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.
Adding 30 or 60 days to a date based on another Cell Value
I am trying to calculate either 30, or 60 days from a date, depending on the value of another cell. Example:
Cell 1: Date
Cell 2: $ Value of less than 50k or $ Value of $50k and up
Cell 3: Date plus 30 or 60 days, depending on the value of Cell 2.