Unparesable Error

Options

Receiving unparseable error when selecting a field in one column and wanting a specific result in another field. This is the formula. What am I missing?

=IF([Submit for Approval]1,1[Manager Approval]1 = "Submitted")

See attached

 

Unparesable Error.png

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    First of all, you can't control the contents of a cell from a different cell. You need to put the formula in the cell you want the results to appear in. 

    In this case, try, putting the following formula in the Manager approval field.

    =IF([Submit for Approval]@row, "Submitted", "Your Text Here")

    If you want the field to be blank when the submit is blank then erase, "Your Text Here. Or put in a different statement for when its not submitted. 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!