End Date minus x#of days =start date


I am trying to enter a formula in a group of rows to have the end date -180days = start date column, but i've tried several different formulas and they all give me an error? Does the dependency to the parent row cause any issues for this - the sheet has 400+rows and i only need the formula in ~7 of them to equal the start date minus the end date = XX


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!