Forum Discussion

kheatley's avatar
kheatley
Qrew Trainee
1 year ago

If/then formula?

Need help with an if/then formula or what I assume is the best way to get the data I need. I have a vacation request submitted into one table that is linked to decision table that needs 5 signatures...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
1 year ago

Are you saying you have a relationship where one vacation request has 5 child decision record.  Then you created a summary field on that relationship?  Does the Summary field have a filter to ensure it's only counting decision records which have been approved?

Also, what if the same person approves twice?

  • kheatley's avatar
    kheatley
    Qrew Trainee
    1 year ago

    I am color coding decision field so they will only be looking for records that aren't green.      

    If([# of Decision records] = 5, "APPROVED", 
   If([Decision - Decision] = "Rejected", "REJECTED", "PENDING APPROVAL"))

    Is there something wrong with logic of this if/then statement on my status field above?  It works for Approved and Pending but not for Rejected.