Best Of
Re: Automated Reminder - Can we hide the sheet weblink
If you create the reminder using the automation work flows, there is a section to customize the message.
At the end of this is the Message Includes option.
If you select the “message only” option, the link to the sheet won’t be included.
KPH
Re: Subject: Issue with Dynamic Remaining Time Calculation in Reports Not Updating Automatically Body:
I hope you're well and safe!
Please have a look at my post below with a method I developed to update the sheet(s) daily.
More info:
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Dashboard View of Report with Gantt - Not opening to "Current Date"
I have noticed that when I post a report to a dashboard in gantt view, the report will display historical dates, even though I have selected open to today's date. The function works properly if I open the report, but the display on the dashboard does not. Any ideas?
Brian_Vaughan
Re: Sheet formulas are not auto-updating until the sheet is opened
For anyone having a similar problem, I have been using this method (automation to record date daily on hidden helper column) for years to keep TODAY() references up to date, and it works well.
Amy.Mizzi.RP
Re: February Question of the Month - Join the conversation and receive a badge
When I was a kid, I wanted to be everything from a superhero, fireman, police officer, doctor, etc. When I look back, the main theme I see is someone who helps people.
As for what I do, in a round about way, I'm doing that. I'm a Project Manager that helps my company implement projects that, ideally, make our customer's lives easier in the healthcare systems.
So limited success. =)
Chris S.
Re: February Question of the Month - Join the conversation and receive a badge
During my childhood, I wanted to be an archeologist, go to Olduvai Gorge to dig. My mother would send me outside to dig up dandelions. :) In high school, I found out about Malaria and decided against my archeology quest. I took some Anthro classes in college and went on to a career in Software.
Kathy PPT
Re: February Question of the Month - Join the conversation and receive a badge
When I was young I wanted to be a teacher. Now I am a planning analyst - married to a teacher.
Deowens
Re: February Question of the Month - Join the conversation and receive a badge
When I was a kid I wanted to sing and dance on Broadway! I majored in music in college, and worked as a studio musician and had a full ride music scholarship. I've sung in bands -- performed in 5 countries in South America, Mexico, Canada, and the US. But.... decided to get a "real job" for financial's sake! I love musical theater and try to see every show that comes to my town. My motto: "Life's a musical, sing it out!"
Pauline J
Re: Index/Match, Distinct/Collect formula question
If you have the users enter the PID into a sheet summary field, you can reference the sheet summary field in the formula and it will still be a valid column formula.
Paul Newcome
Re: Block out calendar dates on Project Plan
Hi @rachkh,
Managing non-working days such as holidays effectively in your project plans is crucial for accurate scheduling and resource planning. While Smartsheet offers flexibility in project management, its approach to handling non-working days might require a bit of manual setup to achieve the desired outcome. Here's how you can address your concerns:
Adjusting Non-Working Days in Smartsheet
- Setting Non-Working Days: In Smartsheet, when you mark dates as non-working in the Project Settings, it's primarily for the purpose of calculating working days for tasks. This setting influences the duration and end dates of tasks that are set to auto-schedule. However, it does not automatically prevent you from manually setting a task to start or end on these non-working days.
- Manual Task Adjustment: If you manually schedule a task to start or end on a non-working day, Smartsheet will allow it, assuming you have a specific reason for doing so. The idea here is to provide flexibility rather than enforce a strict blocking of dates.
Workarounds and Best Practices
- Automatic Adjustment: To have tasks automatically skip non-working days, ensure that your tasks are set to use the "Auto-Schedule" feature. This way, when you enter task durations, Smartsheet calculates the end date based on the working days defined in your project settings, skipping any non-working days.
- Visual Indicators: For a visual reminder of non-working days, you can add a row at the top of your project plan specifically for marking holidays and other non-working days. Use conditional formatting to change the background color of these cells, making it visually clear which days are off.
- Project Templates: Consider creating a project template that includes these non-working days and any other project-specific settings. This can save time and ensure consistency across all your projects.
- Custom Columns: Another approach is to add a custom column to indicate whether a day is a working day or not. You can use this in conjunction with formulas to warn you if a task's start or end date falls on a non-working day.
Bassam Khalil