How can I update two sheets with the same information?
I have a sheet I use to update my teams webinar calendar. Another team in the business would also like to know when a webinar relevant to their team has been added to this sheet, so it replicates on their own training calendar. Is this possible?
I was added as Admin to their calendar. I tried setting up an automation whereby if a column was updated, the relevant row and its information moved from my smartsheet to theirs. But when I checked their sheet, it had not carried across. Is this because the fields in mine and their sheets i.e. in the top row do not match?