Need Workaround Ideas for Automation Condition
Client submits file through form.
I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on people to always set those 2 fields and save before attaching the file to the row.
Without the conditions set, the client gets an automatic reply with the file they just submitted as a response.
I tried changing the trigger to "When rows are added" when a file is attached for the incoming automation and "When rows are changed" when a file is attached as the outgoing automation but that didn't work.
Ideally, I would like to create a checkbox that automatically checks when the submission is older than 10 minutes but I've yet to find a way to do this in SS. I am able to write a formula to do this with Days but need something that would also work if being responded to on the same day which is where I run into a wall.
I'm looking for any kind of suggestion of a way to check a box without any input from our internal user or myself but have yet to find anything. It doesn't have to be time related, it just seemed to be the most obvious.
Thanks in advance