Don't Calculate Column Formula if checkbox is checked

Options
JJMunoz
JJMunoz ✭✭
edited 05/09/22 in Formulas and Functions

Hi, I have 2 columns. One is titled Conception Date that has a formula linked to the column =[Parturition Date]@row - 165 . The other column is a checkbox titled Stillbirth. If the column for stillbirth is checked, I don't want the column Conception Date to populate a date for that row. What formula would I use? TIA

Answers

  • Kevin Smith
    Kevin Smith ✭✭✭✭✭✭
    Options

    Hi

    Would this work for your needs:

    =IF(Stillbirth@row = true, [Parturition Date]@row -165], "")

    This would look for the checked box in Stillbirth and only provide the formula result if checked. Otherwise it would be blank.

    If that doesn't follow what you are shooting for, please let me know.

    Thank you,

    Kevin

    Happy to help if I can.

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!