Help Syncing up two sheets

Annadt503

Our enterprise calendar is housed in smartsheet. Can someone help me with how i would link all dates to my sheet?

Matt Johnson

Hi @Annadt503

If your Enterprise Calendar has the EXACT same tasks/events that your sheet does then you could do an INDEX/MATCH formula on your sheet to bring in the dates. That would send data 1 way to your sheet in view only.

If you want to be able to update dates back and forth and if all the columns on your sheet also reside on the Enterprise Calendar sheet, then you could create a report and have the information bi-directional.

If you let us know the column header names or do a screen shot what you want specifically, we (the Community) could offer more options / specific formulas.

I hope that helps.

Matt