Sign in to join the conversation:
Would you help with an auto checkbox formula please?
I want a checkbox to automatically check yes, if the sheet is 7 days past the created date and another checkbox in another column is not checked by the 7 day mark.
Hi,
Try something like.
=IF(AND(Created@row < TODAY(-7); Checkbox@row = 1); 1; 0)
The same version but with the below changes for your and others convenience.
=IF(AND(Created@row < TODAY(-7), Checkbox@row = 1), 1, 0)Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
