+7Need 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 before it is approved.
Currently, I have the status field in the vacation table that is:
If([# of decision records] = 5, "APPROVED", "PENDING APPROVAL")
Will this work per request? Or do I also have to include record# or something in the if statement.
Thanks for any advice/help.
+15If [# of decision records] is a Summary field between the two tables, that will work.
Question, can a decision record have a value of Denied? The first four might be Approved but the last one is not. If that is the case your Summary formula needs another piece to it so it is counting Approved Decisions and not all Decisions.
+22Are 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?
+15Silly question but where does the field [Decision - Decision] come from? Row 1 is your Summary Field, it has precedence in your logic.
Your If statement defaults to Pending so [Decision - Decision] could be null. Cancelled or any value but Rejected and it will say PENDING.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
