How to Have Formula Continue to Next cell When Dragged Down.


I am creating a delivery & install sheet. On the delivery sheet I have a column that is a date property, on the install sheet the correlating column is also a date property. I am using the workday formula, "(=WORKDAY({Exterior Delivery}, 1, {Holidays Range 2})". The problem is the function won't apply to the other cells when dragged down. It would be extremely tedious if we were to have to type the formula for every single install cell. I tried referencing the entire delivery column, but it just pops up as invalid data type.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!