Linking Rows from sheets to a mastersheet

Hi,

I've got master calendars per customer (grid sheet), from which I copy lines (copy with a workflow, once assigned) to individual calendars. If I make changes on the master calendar, I want it to update on the individual calendar (delete the line if it was assigned to someone new; update dates if it was changed, etc). Also, if I make changes on the individual calendars, I want it to be linked to the master calendars, and update accordingly.

Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!