IF( AND Formula with a Flag

I have a formula that I'm trying to implement, I'm saying if the year closed is prior or equal to 2021 and the finance completion % is lower and equal to 89 percent. Then flag the project. Here is my formula below

=IF(AND([Corporate Finance Completion %]@row = "", [Year Closed]@row = ""), 0, IF(AND([Corporate Finance Completion %]@row <= 0.89, [Year Closed]@row <= 2021), 1, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!