How do you track an automated entry to see where it came from
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.