IF(AND formula to be used with Star Symbol

Hello,

I have an On Time column that when conditions are met populates a colored star. If the store opens after 6 am the star does not color. If the store opens between the hours of midnight and 6 am the star is colored. I keep getting #UNPARSABLE error (the [Value_if_false] highlighted in yellow when i go into the formula.

=IF([Store Open HR]@row = 0, false, IF(AND([Store Open HR]@row > 6, [Store Open HR]@row <12, [Store Open AM/PM] @row ="A"), false, true)

Not sure how to fix this

Thank you in advance

Sharon

Best Answer

Answers

  • Sharon Castiglia
    Sharon Castiglia ✭✭✭✭✭

    I am still getting an unparsable error (Incorrect Argument Set).

    =IF(AND(OR([Store Open HR]@row <=6, [Store Open HR]@row =12, [Store Open AM/PM]@row ="A"), 1, 0)

    Could it have something to do with the "A" as opposed to "AM". I have to use the "A" designation for time formulas

  • Sharon Castiglia
    Sharon Castiglia ✭✭✭✭✭

    Well Genevieve,

    You are a gem. Worked FABULOUSLY. Such a silly error on my part. Learned something new too. You get 👍️👍️👍️👍️👍️

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Sharon,

    Haha no problem at all!! I'm glad it works for you 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!