-
Best practices/overbooking for Smartsheet calendar app?
My company (Bath remodeling company) has our install calendar currently on excel and we do about 22 jobs a day. We are planning to migrate our calendar to Smartsheet calendar app and we are having issues finding a way to provide block outs for some Installers when they request off or how to prevent overbooking. I created a…
-
Using the ,21 (ISO) option when determining WEEKNUMBER - Sheet displays ok, Report doesn't
Hi, When using this formula to return a week number =IF([Date completed]@row = "", "", WEEKNUMBER([Date completed]@row, 21)) the correct week number value displays accurately in the sheet which is good. However, the Report fails to display the column value and displays #INCORRECT ARGUMENT SET Removing the ,21 parameter and…
-
Is there a way to have appointment times appear in the calendar view?
I have searched the help and forums and did not find a simple solution but it sounds like it is an important feature to many users so there must be a solution. Thank You for any advice.
-
Calendar View
Hello, I would like to have my grid locked in calendar view. As it is right now, users would have to select that view for themselves. Also, how can I have a report that is in calendar view display as such in a dashboard? TIA. -BR
-
Is there a way to filter iCal by Sheet levels?
I would like to only show a specific level within a project Sheet's work breakdown structure, so that in an external Outlook calendar, it only shows the level 3 (i.e. task/activity) rows but not the level 1 (project) parent/summary row or level 2 (stage) parent/summary rows - as these all dates also. PS: this is not the…
-
Conditional Formatting into Calendar View.
Hello Everyone! I am trying to transfer my conditional formatting into calendar view but, in calendar view all that comes up if red and white. If I disable that last rule everything turns red... Just not sure what to do here. Any help would be greatly appreciated.
-
Sales pipeline evolution metrics and dashboarding
I own a Smartsheet that captures all of the sales opportunities one per row and each marked with a pre-defined specific stage of the opportunity (investigation, qualification, archive, execution, etc). These will naturally evolve thru the sales funnel and individual smartsheet contributors will update the stage shortly…
-
Publish iCal option is disabled
Hey there! I have created a project that can be viewed in Calendar View and I would like to publish it my outlook calendar, but this option is disabled in my view. Any ideas why?.. it is important to note that this is not a report (I know this option doesn't work with reports), it is basically a track for release notes…
-
Start Date / Alert Someone
I know I am over thinking this but I am trying to figure out 2 week look out. Lets say Start date 7/20/21 and I want Smartsheet to give me an alert 2 weeks before. What is the correct set up in Smartsheet?
-
Calendar linked to outlook
Hi, I have created a calendar and have linked it to outlook. But for some reason I see only the start date in Outlook and not the end date. A 2 days appointment is showing up only on the first day. In Smartsheet and in the calendar app it showing up correctly. Thanks Christine
