I have a sheet that is pulling data from a second sheet. What I want to happen is when the status changes to RECEIVING COMPLETE on the second sheet, it checks the box in the received into stock column. The problem is that once that status is updated to that value on the second sheet, it's moved onto an archive sheet that changes based on the fiscal year and quarter. A formula won't work because it is constantly refreshing and the box would uncheck when the line disappears from the second sheet, so I figured I would try an automation to prevent it from constantly updating. The problem is that we ran a test, and the box never checked or unchecked, then we tried to do the same thing but have the automation record the date, and that didn't work either. I also do not have the ability to change anything on the second sheet, I can only pull data from it with formulas.
Let me know if you need anything else.
