Creating a calendar that is populated by dates on other sheets

10srahman

Good day, 

Right now, we have several events happening in different cities on different days. For each event, we have a separate smart sheet, with individual planning tasks. but we want to have a combined calendar with just the dates of the actual event. I thought that I could do this by linking to the specific cell with the date. While that feature works for filling the grid (attached) , it doesn't populate the calendar (also attached). Can we make the calendar function work? That would make life - AMAZING. 

Thank you,

 

Andrée Starå

Hi,

Have you checked the calendar settings and which column(s) it should look at?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

10srahman

Hi Andree, 

Yes, I checked the columns. They are correct.

If I input a date manually it updates the calendar updates, the linked cells do not update though. 

 

Thank you for your response!

Andrée Starå

Happy to help!

I'll test a little and get back to you!

Andrée Starå

Happy to help!

I just tested, and it's working for me.

How did it go for you?

Genevieve P.

Hello, 

Can you confirm that the column with the cell links is set up to be a "Date" column type? (Double click on the column header to edit column properties.)



If it is a "Date" column, your sheet has been saved with these links, and your calendar's settings are pulling from the "Training" column, and yet you are still not seeing the dates in your calendar, please reach out to support@smartsheet.com.

Please provide us with your sheet name, the images you have above, as well as the information on column-type and calendar settings and we will be happy to help troubleshoot further. 

Thank you!



Genevieve