FAQ
How can we help?
Full Site Search

How to Use Formulas to Obtain and Determine the Value of the Approval Status Fields?

If you have configured an approval flow on your sheet, and have also added the approval status field to state the approval status, in addition to the fact that you would like to use a formula regarding the field value (such as using a IF() formula), then you would need these values to use your formulas correctly. Below is the chart for the values that each type of status refers to.

Displayed Status on Approval FieldValue Used in Formulas
Not startedN
RejectedREJ
ApprovedF
In processP

Therefore, if one of your fields would like to use a formula to reference the approval system field, the value would be "F" when this entry has completed the approval rather than "approved".

Furthermore, if you would like a field to display the approval status of the system field stating the status of the approval flow, you can additionally use the IF() formula. Let's say you've created a new field and applied the following formula.

IF(A1.RAW="N","Not started",IF(A1.RAW="P","In process",IF(A1.RAW="F","Approved",
IF(A1.RAW="REJ","Rejected",""))))

This means if the value on the approval status field located in cell A1 is "N", the new field's value will be "Not started"; if the approval status field's value is "P", the new field's value will be "In process"; if the approval status field's value is "F", the new field's value will be "Approved"; and if the approval status field's value is "REJ", the new field's value will be "Rejected".

Top of Page

    Start Ragic for Free

    Sign up with Google