I need help with publishing my smartsheet to Google Calendar

Taryn Franks

When publishing a sheet to Google Calendar can I have only 1 of the date columns show up in the calendar?

Genevieve P.

https://community.smartsheet.com/discussion/comment/282700#Comment_282700

Hi @Taryn Franks

Yes, you can definitely do this! You just need to adjust the Calendar View settings for which column it's pulling dates from. Here's the image from the Help Center which shows where you can make this adjustment:

Once you've configured the Calendar view you can publish it to your Google calendar.

Taryn Franks

This also could have been published already, I'm new here and new to smartsheets so sorry if its a repeat question.

Bassam Khalil

hi @Taryn Franks

Hope you are fine, please read the following article i hope it will help you to understand the Use of Smartsheet Calendar with Google Calendar

Genevieve P.

Hi @Taryn Franks

To expand on @Bassam.M Khalil's answer and reference to the Help Center documentation, the Calendar View can look at a maximum of two Date Columns, but these would be the Start Date for the row and the End Date for the same item/row.

Would you be able to describe your scenario a little more? We may be able to come up with an alternate solution if you have multiple date columns. I would also recommend reviewing the Calendar View Help Center article, here: Work with Calendar View

Cheers!

Genevieve

Bassam Khalil

@Genevieve P

I need your help in profile editing how i can call you.

Taryn Franks

@Bassam.M Khalil Thank you! I will look at the article.

@Genevieve P Thank you for the response! Will also check out the help center.

More details on my scenario: I have a smart sheet that is basically a to do list with different assignee's for different tasks, date requested, date required and date completed columns, I want it to publish just the task and the date required into google calendar, currently its giving me the date requested and date required which when these dates are months apart it covers my calendar for the whole duration. Is there a way to have it just pull 1 date?

Andrée Starå

https://community.smartsheet.com/discussion/comment/282692#Comment_282692

Hi @Bassam.M Khalil

I just came to think of one thing you could try regarding editing your profile.

Have you tried Ctrl + Enter?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Hi @Andrée Starå 

Hope you are safe and well, yes i tried CTRL + Enter & ALT + Enter but it does not work. 

Andrée Starå

@Bassam.M Khalil

I'm excellent, and I hope you are too.

What happens when you try Ctrl + Enter? Have you tried doubling it?

Bassam Khalil

@Andrée Starå 

Yes i tried but nothing happened 😔

Taryn Franks

@Andrée Starå, @Bassam.M Khalil

Separate question here but when using the Smartsheet ios app is there a way to use the filter option? or only sort?

Also @Andrée Starå any insight on my original question about google calendar only pulling from 1 date column?

Thanks in advance!

T

Genevieve P.

https://community.smartsheet.com/discussion/comment/282700#Comment_282700

Hi @Taryn Franks

Yes, you can definitely do this! You just need to adjust the Calendar View settings for which column it's pulling dates from. Here's the image from the Help Center which shows where you can make this adjustment:

Once you've configured the Calendar view you can publish it to your Google calendar.

Andrée Starå

Hi @Taryn Franks

I hope you're well and safe!

1. You can filter in the iOS app, but you can only select the ones already created.
2. It's working for me. Can you share some screenshots of the settings and more?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Genevieve P.

https://community.smartsheet.com/discussion/comment/282692#Comment_282692

Hi @Bassam.M Khalil

If you need to contact a Community Moderator or Admin (such as myself), then please use the Report button on a post to send us a private message describing your question or issue. You can Report this FAQ here, instead of using a specific thread.

You can also provide feedback on the Community platform through the form in the top left menu (see this FAQ: Where do I leave feedback for the Community and/or Product?

Taryn Franks

@Genevieve P Got it from the article you sent me! I really appreciate it, thank you!

@Andrée Starå Thank you. I think I figured it out

Genevieve P.

@Taryn Franks Great! I'm glad you got it working 🙂