#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

Options
✭✭
edited 12/09/19

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

Tags:

• ✭✭✭✭✭✭
Options

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?

• ✭✭
edited 08/18/16
Options

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!

• ✭✭✭✭✭✭
Options

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

• ✭✭
edited 08/19/16
Options

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

Much appreciated!

• ✭✭
Options

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