-
Filter Cards by Phase/Title of Parent
Is there a way in the Card View to filter and only see cards within a certain phase or cards that have the same 'Title of Parent'? I have a multi-phase project with hundreds of total lines and it would be great to be able to break up the cards to only focus on the current phase of the project. I'm also open to any other…
-
Automated task status in a project plan
I am building a project plan and would like to have the "Status" to be automated based on the % a team member fills in for a task. I've tried several of the IF OR and IFAND statements and they work partly. I can get the "Complete" and the "Not Started" to work but unable to figure out the "In Progress". When I try to nest…
-
SIGHT Metrics
I am part of a PMO and we track all projects on one sheet. The PMO covers multiple lines of business within our organization, thus I have a Sight set up per line of business. In each Sight, I would like to be able to show the number of projects in each RYG status. What is your recommended approach for doing this? I've been…
-
Features that Smartsheet Should Add
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…
-
Project Resource View
Hi: I'm looking for a way to where the Project Resource View will list actual Task Names against each resource in my project sheet instead of the smartsheet file name against each person. . Is there a way the Project Resource View can be tailored and utilised as a resource management tool?
-
Sights: Sheet Name Link issue
I am having an issue with my Sights where I have a Report Widget and within the report is the "Sheet Name" link. From the Sight, the first time I open, the Sheet Name link does not work. I have to first click in any other column to open the Report, and then the Sheet Name link will take me to the row on the Sheet. I can…
-
Sum of hrs utilized per client
Hi Smarties, I created a time tracker with each column with drop down list for different clients. 1. I want to sum all the hours used per client and to appear in one cell per client, so I can link the cell to auto populate. I am familiar with step 2( cell linking). Can someone suggest how to run the report on a sheet with…
-
Changing Fiscal Year Start YEAR in Gantt Settings
It is possible to change the fiscal year to be the previous/current calendar year, vs the default of current/coming calendar year in the Gantt settings? My company uses a delayed April start. Thanks!
-
Website migration project
Hello, I'm a new Smartsheet user, managing a large health care website redesign project. We have a large amount of content to move from an older CMS to a new one. We're also moving from a static to a dynamic site environment. Are there any users here who have used Smartsheet to manage and track a large content migration…
-
Max number of entries in drop down list?
Hi; Is there a limit to the number of entries in a drop down list? Would a list of 1200-1500 names have an impact on performance? We don't need validation or conditional formatting (e.g. red for a value is entered that is not in the list). Are there best practices for a task like this? Thanks in advance, Andrew
