Returning a YES value
Debbie Petersen
✭✭✭✭✭
Trying to get a formula to evaluate 2 columns and if the 1st column is CURRENT and the 2nd Column is CHECKED, return a value of YES, and if either column doesn't show the CURRENT of CHECKED, return a value of NO. Have tried many combos and think I'm close - what's missing or wrong here:
=IF(AND([Ins Status]@row = "Current", [Agreement EXE]@row 1), YES, NO)
Included a snip. THANKS!!
Tags:
Comments
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!