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
Silly 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.
Comes from Decision table, is a dropdown of Approved, Rejected, linked via relationships to vacation request table.
