Don't Calculate Column Formula if checkbox is checked

JJMunoz

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

Kevin Smith

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.