Help Syncing up two sheets


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


  • Matt Johnson
    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 Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!