Formula to check box if Date is 7 days ago
I have an idea to help me initiate an update request to add a new row. I'm thinking about adding a helper column with a checkbox and a column formula to check the box if the Date in the previous row is 7 days earlier than today.
Do you think that will work and if so, can you help me with the formula? Mine is not working.
I've attached a screenshot of columns and my formula which would be placed in row 2 to look at the date in row 1: =If([Date]1, TODAY(-7), 1, 0) This formula does not work... Invalid Data Type.
What is the proper formula and IMPORTANTLY, will it be possible to make it a column formula where each row will look at the date in the previous row?
Help Article Resources
Check out the Formula Handbook template!