-
Setting up automatic reminder system
Hello community, I have a tricky question here concerning how to send out a reminder automatically based on the following idea. I have a sheet which lists the status of certain rows. Each row has a column that indicates with Green/Yellow/Red/Gray dots (symbols) - these indicate if an item has been fixed, pending, still…
-
Smartsheet to Outlook Tasks
In my Smartsheet projects, in addition to the usual statuses of "complete", "in progress", etc. I have a status called "Action Item" where I designate items that I personally need to take care of. Is there a way to make these items appear as "tasks" in my Outlook? (reason: I prefer to block off times for my tasks in my…
-
Send Outlook Calendar invite to Smartsheet to update Calendar
Is it possible to send an outlook invite to Smartsheet to update a Smartsheet calendar? We use Smartsheet calendar to publish the calendar and still have to schedule meetings via Outlook. It would be more streamlined to include our Smartsheet as an invitee to automatically update it.
-
Release Milestones
I'd like to establish a row that holds our release schedule. Every three weeks I'd like some visual marker that indicates that we've got a new release. That seems possible in Smartsheets, but establishing a cadence of milestones seems to require individual rows for each release. Is there a way to place markers without…
-
Can your event span time in calendar view?
I am using Smartsheet’s Product Release Roadmap form. I added a start date and an end date to the cards so that the projects can span a period of time in the gant view. Is there a way I can make it so they also show as spanning a period of time in the calendar view? Currently, each individual card is only showing as the…
-
Course seat registration
Hi, I'm trying to set up a form for people to use to register for specific seats in specific courses. For instance, on the form, I should be able to select course A with my name and email . At that time, 1 seat from course A on the sheet should be populated with this data, and the number of available seats should reduce by…
-
IF formula with Condition on dates
Hi there, can anyone help me on this formula ? it looks the only issue could be on the date format but I don't know what I have to change. =IF([Expected Order Date]4 < 3 / 31 / 18, "1Q 18"; IF([Expected Order Date]4 < 6 / 30 / 18, "2Q 18",IF([Expected Order Date]4 > 9 / 30 / 18,"3Q 18","4Q 18",)))) Thanks a lot in…
-
Export to Google Calendar although no longer syncing from smartsheet
Question- We would like to export the calendar to Google Calendar. I am familiar with the publish feature but it appears that it will only create a new calendar and can't be added to an existing Google Calendar. 1. Is this correct? I would like to export all entries into Google Calendar but not have it synced, meaning if I…
-
Need to show same event repeated on different separate dates on calendar view of my marketing plan t
For example. An email has to go out every Tuesday to all employees starting from say July until September. Or a teaser to be posted on social media on specific dates. July 2, July 10 July 14 and July 18. So basically I need to have multiple dates- in column cells be highlighted/colored (in the calendar view) for the same…
-
Calendars
Hi, I'm currently importing a Gantt project backup from another application to view in Smartsheet's calendar view. I wonder is thetre any way to merge several backups in one calendar view?
