Don't Calculate Column Formula if checkbox is checked
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!