Combining If/then with date population

I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below)

I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive".

Any tips? I'm definitely running up against a wall on this one!

Best Answer


  • Hi @Megan T

    The new Healthcare Community Group is now live! This group is a space for all things Healthcare and your question sounds like a great use of a discussion post in the group. I encourage you to ask questions, share use cases and collaborate with others in your industry. We will also have some excited healthcare-related updates being announced in the Healthcare Community Group very shortly.

    Please let me know if you have any questions about the new group! 


    Brianne Laird, Sponsorships & Brand Activations Program Manager

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!