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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAre 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?
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.