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
my formula is returning number of dates, as in adding dates.
My goal is to have the percentage update automatically each day. If the task has a duration of 45 days and we are 3 days in, I need it to show the percentage complete. It would cap at 100% once it has reached the end date
Disregard. The problem was additional dates on collapsed child rows. Thank you. Good afternoon. I have created a metric sheet that was then used to create a chart. The formula is written as: =COUNTIF({Date of Visit}, IFERROR(YEAR(@cell ), 0) = Year@row ) This was then drug down for 4 rows. Rows 1, 2, and 4 have the correct…
