Formula

Options

Hi

I'm trying to return a boolean based on another column - If the column is blank, or the date is within the last 7 days, I need a 0 to return, if it's not blank and the date is greater than 7 days from today, I need it to return a 1. I'm currently using this formula:

=IF(OR([Current & Pipeline Last Updated]@row = <=TODAY(-7))[Current & Pipeline Last Updated]@row = "", "0", "1")

But it doesn't like it so, my parenthesis or commas are obviously wrong somewhere? Sorry, end of the week and my brain is now broken! 😊

TIA

Cheryl

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!