If(And) #unpareseable error- help

karlinlh
karlinlh
edited 12/09/19 in Formulas and Functions

Hi I am trying to write a formula to check values in two columns to set a flag on or off.  If I write them independently without the AND function they work but when I write it with the AND I get a #unparseable Error.  Here is the formula- =IF(And([Planned Finish]@row > TODAY(), [% Complete]@row > "100%") 0, 1).

 

Any guidance would be appreciated,

 

Thanks,

Lisa

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!