IF AND with check box and other criteria

I'm sure I'm just missing a comma or something silly that my brain is not catching, but can I get an assist on this one?

Deducted from Purchase Price is a check box column

Accepting Extention? is a text column

I want to add the value from the Amount Due column if the check box is checked and if the cell in Accepting exertion is Yes. I keep getting an #unparseable error message.

=IF(AND([Deducted from Purchase Price]@row = 1, [Accepting Extension?]@row = Yes), [Amount Due]@row,0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!