Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF/AND Formula

Joshua Rose
edited 12/09/19 in Archived 2017 Posts

Hi, I am following identical logic to another formula in my sheet that is working, so I cannot for the life of me figure out why this is not:


=IF(AND(Eval Payment Status]1 = "Appointment Pending (pay plan)", [Initial Pay Plan Amount Due]1 = 0), 1, 0)


Here, I am trying to establish that IF Eval Payment Status shows Appointment Pending (pay plan), AND Initial Pay Plan Amount Due is blank, then check the box.


Any thoughts greatly appreciated. 





This discussion has been closed.