How do you track an automated entry to see where it came from
Hi,
I have an automation set up in my Primary Sheet that lets me know when an intake has been approved in my Project Intake sheet and on the Project Intake sheet I have a formula that inserts data in the Primary Sheet when it's been approved.
The question I have is, I received a notification that a new row has been added to my Primary Sheet, which means that a new project has been approved, but when I look at the Intake sheet where the approval happens this specific ID is not there. How do I check to see where this information came from? I can only see who set up the automation, but it doesn't show me from which sheet the data is coming from.
Thanks
Answers
-
The automation can only trigger from rows that are on the same sheet. If the automation came from the primary sheet, then you would need to check the primary sheet (not the intake sheet) for whatever triggered the alert.
-
I know the automation is in the Primary sheet, where the new row was inserted, that is correct. What I'm battling to find is where the data is coming from. So there is a from that needs to be completed and that form is linked to the Intake form, but the information that should be coming from the intake form is not there, we cannot track were it is coming from.
-
Have you checked cell history in one of the cells on the new row or the activity log?
