-
Calendar app yearly view
Hi Community, I have build a calendar via the calendar app and it works quite well. But the question came up, if we could create a view where you are able to see the complete year with the task. I linked it with the google calendar but you are able to see only the days but not the task. I would like to have a view like…
-
How to Round up date from delta for dates
I have a spreadsheet where I've gotten the Delta (time between end date of task 1 and beginning of task 2). it comes out as an integer instead of a whole number to reflect days. How can I use the ROUND function to reflect whole integers? An alternative: is there a setting within the Smartsheet that would allow for whole…
-
Suppressing Legend in PDF?
Hi, I want to download a view from the Calendar app to PDF, but don't want the legend to show. Is there a way to suppress the legend from showing via Smartsheet vs. having to use an external PDF editor? Thanks~
-
Copy Row Automation causing duplicates
I am using an automation that copies rows which contain the word "submittal" into a sheet where we are tracking submittal dates for all our projects. I cannot use a report because we need to be able to publish to a calendar. Therefore, the end result must be a sheet. As most of you probably know, these dates can change…
-
Times in Outlook Calendar Syncing
I haven't been able to find a way include times with Outlook Calendar sharing after the last Outlook update. Any help on how I cna do this so that each event isn't listed as an "All Day" item would be great. Thanks
-
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…
