-
Use a sign up cap within forms
Hi, New to to community and couldn't find the thing I am looking for, hopefully someone is able to help. I am trying to gather sign ups for different events in one sheet using forms. The events got different sign up caps (max attendees). After an event is fully booked and reached it's cap people shouldn't be able to sign…
-
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…
-
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.
