-
Integrating non working holidays on another country
Hi fellow Smartsheeters, I encountered this problem after entering American holidays but our operations is affected by other suppliers in other countries like China. I think many of you have been affected by week long holidays like Chinese New Year week. Is there a way entering a certain countries holiday without making it…
-
Merged: Version History
This discussion has been merged.
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
Prevent Unintended Changes by Disabling Removal of Logic when renaming dropdown items
I was editing the value fields within the column. One of the dropdown answer choices was “New Request”. I simply just added a new word “New/Continuation Request”. When I added the new word, that’s when I found all of the associated logic removed. I never removed a field so in theory, the associated logic shouldn’t have…
-
Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of…
-
Merged: Predecessor links maintained when copying rows
This discussion has been merged.
-
Creating Charts from Reports
Hello, I am trying to create a chart from a report to have in my Dashboard. I have a report pulling my Engineer's Hours per project, and would like to create a way to sum all those up and create a graph showing this. Any help?
-
More than one Baseline + Comments
Dear all, To enhance Smartsheet as a comprehensive PM Application, my company and I find that a crucial feature, baseline management, currently needs to be added. While the ability to set baselines is valuable, the limitation of only being able to set one baseline is a constraint. We propose the implementation of a feature…
-
At Risk formula include when Status is <blank>
Getting started in Smartsheets for Project Management. I've been reading a number of Q/A on creating formulas to flag At Risk. I want to flag any task 3 days before the End Date or if it's past the End Date. Additionally, flagging any task where the Status is NOT Complete. Here is what I've been using so far: =IF([End…
-
Pull Data from Another Sheet based on Criteria
Hello, Below is my master file of projects. I've filtered to show all the values based on "Automation" in the Drop Down column. Each project is designated with a project #. I want this sheet to function as a way to automatically carry over all the project #s from the master file to my new file (see below) based on all the…
