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

Marie ✭✭
edited 12/09/19 in Archived 2016 Posts

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
    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
    Marie ✭✭
    edited 08/18/16

    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
    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.



  • Marie
    Marie ✭✭
    edited 08/19/16

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

    Much appreciated!

  • Viktor
    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!

This discussion has been closed.