-
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
-
How to move information with a workday function?
I work for a bath remodeling company and we have installers with level 1, 2, 3 based off skillset. I need a way to plan availability based off the amount of installers we have and their levels. Right now the date column reads, =WORKDAY(TODAY(0), Label@row) and this allows the dates to update automatically. I originally had…
-
How to Incorporate Durations in COUNTIF formulas with Calendar App
Hey all, I am having issues rolling up calendar availability with the durations. If you look at the calendar attachment picture, I want to have 3 jobs scheduled for 7/17/21 but we have a job with a duration of 2 days the day prior which makes it more like 4 jobs scheduled. I have a cross-sheet reference off the main…
-
Moving up start date on calendar app
When I move the start date backwards on the calendar app, I have no issues. However, when I try to move up the start date past the end date, I receive a message saying, "End date must be greater than or equal start date". Shouldn't the end date just follow the start date if I have project settings enabled? I have the sheet…
-
How do i create a calendar within forms that will block off certain dates?
I have created a form that I am using to send to people to sign up for something. I need them to be able to select a date, but have some that aren't available to be crossed out. Some dates will be able to have about 10 people sign up for, so that date will need to be crossed out once that limit is reached.
