Auto fill date


Is it possible to set a date cell to auto-fill based on a date from another cell?

I'm setting up a task list which tracks the ordering of materials required to sites. I have a column 'date required on site'. I am adding another column 'order to be placed by'. If we know that the supplier requires say 3 weeks notice to meet the delivery dates, is it possible to set the second column to auto-fill based on the first column - 21 days.

Hope that makes sense.

Any help would be appreciated.

Thank you


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!