-
Creating symbols from drop down column for display within tile of Calendar App
Not sure this ability exists... may be an enhancement request, but would value any input others might... I would like to be able to display various symbols to represent the different drop down choices of a specific column, and then have those symbols shown on the calendar tile as applicable, with a legend then shared at…
-
Completed Tasks removed from calendar
Is there a way to remove completed tasks from the calendar without removing them from the sheet? I have a done column that checks off and greys out the row but the information still shows up on the calendar is there a way for it not to show up on the calendar? Thanks in advance.
-
Calendar View
I have a Calendar for announcements that that is imbedded in a dashboard. How can I set the view to default to show today's date. Right now it defaults to Feb-Mar 2020
-
Smartsheet at- risk formula
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column. I only want the column to flag is the status is not complete and the target end date is past due. My current formula is =IF(AND(Status301 <> "Complete", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…
-
Setting up access to a Smartsheet Calendar in Outlook
We are migrating our vacation and PTO requests into a Smartsheet. We would like the calendar view that our payroll admin has of all the approved time off to be available for all to see in outlook. I took the webcal link and shared it with several staff members to see if they could access the calendar. It looks like it…
-
How can I keep the colors in the calendar app view from changing when data is changed?
I built a calendar view from a report (no pre-selected colors assigned), which has primary and secondary grouping. The colors assigned were fine, however whenever the in-line data was changed through the detail view that pops up when you click on a calendar bar, all the colors for the entire view would change to other…
-
Calendar as default view when shared in Teams tab
Is there a way to ensure a Smartsheet imported to Teams always displays in Calendar view? I think I have been able to save this view as the default in Smartsheet itself, but when I open the sheet's tab in Teams it displays as grid view. I signed out of Teams and signed back in to check whether the changes just needed to go…
-
Change the color of Task Bars in Calendar View
I would like to change the color of task bars in calendar view. I understand I can right click and change these one by one, but I would like them to change automatically. I have tried manually changing the rows in Grid View to reflect the color I want the task bars to be in Calendar View with no luck. I also used…
-
Options to show multiple project plan sheets into one view
I currently have a project where I have project plan sheet for each country. I'd rather keep them separate than combining into a single sheet, however I'd like to show the combined details in Gnatt view and checking for date overlaps. Has anyone tried to do this before?
-
How to hide columns in callenderview
Inside a Report i can choice what columns i want to show in the grid and gantt view, however if i switch to callenderview and selected a project it shows everything. is there a possiblity its only shows the choisen columns.
