How to cross reference dates on a master sheet and then edit those dates on different worksheet?

Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project are subject to be delayed due to construction, permits, etc. I would like to only have to change the dates on the master critical date sheet and then all the connected worksheets would have their task start dates updated based on the master critical date sheet.

What formula do I use to cross reference (or should I just link cells?) the critical date to a different worksheet and then be able to edit those dates to read such as "Start Date=1 week before critical date," "start date=same as critical date," "start date=2 weeks after critical date", etc.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!