I have a question about making a column static after the first time it’s added to a sheet.
For example I am retrieving emails based on a pending category. I have a column for the current date and a column for the date that the email started pending which also starts at the current date. (4/4/2024 And 4/4/2024). But If the bot runs the next day and that email is still pending then the current date will be 4/5/2024 and started pending date should still be 4/4/2024 aka static. I need this to keep track of days pending for the email. I cannot use received time because an email does not get categorized right away. So basically the started pending column should get the date once and stay static forever. I have tried If conditions but no luck.
Is the pending date and current date explicitly specified in the use case?
If so, have you tried conditioning the process not to write to a cell when it already contains a value?
Oh okay, so if I’m getting you clearly:
Each email has their own pending date that may or may not be different from the current date and you want to write this pending date to each email’s row in the pending column and keep it that way?
