checked box after 3 cells have been filled.

Jlind · 01/03/22

I am trying to figure out a formula to have a box checked once 3 dates have been entered, please help me! Thank you :)

Kelly Moore · 01/03/22

=IF(COUNTIFS([Visit 1]@row:[Visit 3]@row, ISDATE(@cell)) = 3, 1)

cheers

Kelly

Kelly Moore · 01/06/22

The formula above should convert to a column formula. Were you able to copy it directly into your sheet?

This article explains the criteria for column formulas.

If the article doesn't diagnosis the problem, can you provide a screenshot (the colored text) of your formula in your sheet?

Kelly

Kelly Moore · 01/03/22

=IF(COUNTIFS([Visit 1]@row:[Visit 3]@row, ISDATE(@cell)) = 3, 1)

cheers

Kelly

Jlind · 01/05/22

Hi @Kelly Moore, thank you very much! that works for checking box but I can't convert the column into a formula column, do you maybe know why?

Kelly Moore · 01/06/22

The formula above should convert to a column formula. Were you able to copy it directly into your sheet?

This article explains the criteria for column formulas.

If the article doesn't diagnosis the problem, can you provide a screenshot (the colored text) of your formula in your sheet?

Kelly

Jlind · 01/06/22

it worked... i checked for some reason i had the formula not with @row but with the number of each row... thank you🤩

Best Answers