Sheet Name Appearing within Google Calendar Milestones

kokrongley66406
edited 12/09/19 in Smartsheet Basics

I understand that when publishing to Google Calendar the Smartsheet Name appears as the Calendar Name. My scenario is this: I have 5-10 projects going on at one time for one given client. So, if I am viewing all calendars at one time, the tasks/milestones are difficult to differentiate. Is there a work-around so that the project name appears within the Google Calendar view, and not just within the calendar name?

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi,

    A possible workaround would be to show the information in the primary column but if it will work depends on your setup in general. 

    You would need to use another column for the information that you previously had in the primary column, and it will affect other areas in Smartsheet. You would also need to add another column to have the project name in.

    =[Project Name]@row + " - " + [Alternative Primary]@row

    Will show as "Project 1 - Task 1"

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma

    Would that work?

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.