If/Then formula with two options based on a date?

Options

Hi all,

While I am getting the hang of Smartsheet, I'm still a novice with formula. I currently have a column formula

=[Record Entry Date]@row + 8

This adds 8 days to the "Record Entry Date" to create an "Archive Date" for each row.

However, I now need to adjust the formula to be either 8 days or 30 days, depending on the entry in the "Audience Campaign Status" column.

-- If the Audience Campaign Status is "Inactive," then I need to make the Archive Date 30 days after the Record Entry Date.

-- If the Audience Campaign Status is "Active," then I need to make the Archive Date 8 days after the Record Entry Date.

This has me stumped, as I'm still figuring out nested formulas. Does anyone have any advice?

Thank you!

Best Answer

  • sharkasits
    sharkasits ✭✭✭✭✭
    Answer ✓
    Options

    @jmhoward You can use and IF function for what you're trying to do. Assuming Active and Inactive are the only options, the below formula should work.

    =IF([Audience Campaign Status]@row = "Active", [Record Entry Date]@row + 8, [Record Entry Date]@row + 30)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!