Is there any issue with the “Record the Date” functionality on linked cells?
I want to create an automation for Record a Date: when a cell is equal to “Complete” then record the date when that happened. This essentially works when I manually enter this value in the cell (see screenshot - last row). However, I want to have this linked in from another sheet and then it fails. The data is correctly set to Complete, but the date is not recorded. On the screenshot you can see that the data for rows 1 to 3 is linked from another sheet. Is there any issue with the “Record the Date” functionality on linked cells? Does somebody know?