Formula not working in Smartsheet when data is populated from form

Mandy Campbell
edited 01/07/22 in Formulas and Functions

I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form.

Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!