Calculate Date Column dependent on number column

Hi Everyone,

I am looking for assistance writing a formula for one of my sheets. I have the following columns:

Visit Date

Screening Score

6 Month F/u Date

12 Month F/u Date

What I am looking to do is have the 6 follow up dates calculate from the visit date only if the screening score is above 9. If it is 9 or below, I would like the 6 month field to remain blank and the 12 month field to populate.

I will admit that formulas are not my strong suit. I have tried this a few different ways and keep getting error messages. Any assistance is greatly appreciated! Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!