Formula for when if a checkbox is checked...or not

Marie

What would be the formula that would return "True" if a checkbox is marcked as checked and "False" if it is not? Thank you!

John Sauber

This can be done. A simple version for row 1 would look like

 

=IF(CHECK_COLUMN1 = 1, "True", "False")

 

Doesn't a check mark do this by its very definition?

Marie

Thanks so much John, this is exactly what I was l was looking for. It is part of a much longer logic formula.

Now, while you are here do you happen to know how to express an in between condition? Here is my problem: I want to say that if the Mid-Term report due date is over due between 0 and 7 days, then ... What would be the syntax for the part in italic below?

 

IF(TODAY() - [Mid-Term Report Due Date]1   is between zero and 7

 

Thanks a lot!

John Sauber

Your criteria will not flag things that are very overdue, just so you know. I assume when you say between 0 and 7, that's 1, 2, 3, 4, 5, and 6 days overdue only. You can change the values, of course, or change them from > to >= or from < to <= to include your limits. I think you should be able to take it from here.

 

Nother tip: we prefer to show true and false is with a checkbox, flag or star column type; it's better than listing "true" or "false" as you'll see below.

 

https://app.smartsheet.com/b/publish?EQBCT=1262fc277a7d4d86bdc51ab1ac21dc3e

Marie

Thanks so much John. I got my whole formula to work.

Much appreciated!

Viktor

Hi there,

could someone help me with this formula?



=IF(Completed22 <> 1, IF(TODAY() - [Due Date]22 > 0, "Red", IF(TODAY() - [Due Date]22 > -7, "Yellow", IF(Completed22 <> 0, "Blue","Green")))))



Not sure what needs to be changed to get it running.

The idea is to indicate:

Green = more than 7 days remaining

Yellow = 7 days remaining

Red = Overdue

Blue = Done

Many thanks in advance!