Good Morning Monday Crew!
I am wondering if anyone would have a suggestion for the following scenario?
I have a board in which users submit requests to, using the form view. The board assigns the requestor as the ‘requested by’ and notifies them that their request has been submitted. They have to enter an amount ($), among many other details, of their request. Here is where I am stuck and hoping that there is a solution…or perhaps I have hit limitations!
- When user ‘1’ submits their request and it is in the amount of ‘x’ it is auto-approved and moved down the board to the next group.
- When user ‘1’ submits their request and it is greater than ‘x’ but less than ‘y’ it sends a notification for another person for approval before moving down the board to the next group.
- There could be a third instance where it is greater than ‘y’.
I know that I can create formulas to change the status of another column but I am not sure how to tie that in to notifications of others.
Thanks in advance for any assistance I can get on this.