I can't figure out what's wrong with my formula. I keep getting an "#Unparseable" Error. Help?

Thomas Lince
Thomas Lince ✭✭
edited 07/09/20 in Formulas and Functions

Can someone help me figure out why my formula keeps giving me an error? I can't for the life of me figure it out:

=IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + Green#, [8p LTC Peak]2 > 0), "Green", IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + [Blue]#, [8p LTC Peak]2 > $[8p LTC Peak]$1), "Blue”))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!