Unparesable Error

michael.lane77246

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

 

Mike Wilday

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.