I have a formula in place to have a certain value in a cell if the modified date is today "Updated", and if not display a different value "Not Updated".
However, this seems to work when I open my sheet the next day the value is "Not Updated", but then the modified date updates after saving,
I'm looking to add a formula which will check the dates in modified and created columns and update the status column. If the modified date is today and is greater than the created date I want to populate the Status column with "updated", but if the modified date is equal to today and if the created
We use zapier to add rows to the top of our primary active sheet from Pipeline. Within the active sheet are formulas set up for adding dollar amounts and hours. When a new row is added, these formulas carry "up" to the new row added in.
However, I have an "IF" statement that will translate zip codes