Returning a YES value

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!!

Find more posts tagged with

Construction

Formulas

Comments

L_123

=IF(AND([Ins Status]@row = "Current", [Agreement EXE]@row = 1), "YES", "NO")

Just missing an equal sign and some quotes

Debbie Petersen

AHH! Thank you so much!

Sign in to join the conversation!

Quick Links

Trending discussions

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet