Forum Discussion

Qrew Member

4 days 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

Qrew Legend

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

Qrew Member

4 days 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.