Automate dates


Hi, I'm trying to automate dates being filled in based on a certain schedule:

Basically C1D1 is day 1 and C1D2 is day 2 and so forth...

I'm envisioning a formula that reads "if [Visit #]@row contains D2 (or whatever day), then add 1 day or 2 days, etc. to day 1.

I have part of the formula:

=IF(CONTAINS("D2", [Visit #]@row), Planned2 + 1)

But I'd like to optimize the formula so that I can make a column formula and it will take the ((day x-1) + day 1). I think I need a LEFT function somewhere.

Thanks for your help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!