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
Marie
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!

Tags:

Comments

  • John Sauber
    John Sauber ✭✭✭✭✭✭
    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?

  • Marie
    Marie ✭✭
    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!

  • John Sauber
    John Sauber ✭✭✭✭✭✭
    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

  • Marie
    Marie ✭✭
    edited 08/19/16
    Options

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

    Much appreciated!

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

    Many thanks in advance!

This discussion has been closed.