-
% Complete column not computing
My project row «SCC Project Name» is the parent row (hierarchy level 1). The phases under it are indented as child rows (hierarchy level 2). Phases= Initiating, planning, executing, closing. The % complete is not computing on the main project row (22). It also will not allow me to enter a formula. They are not locked…
-
Data in a Dashboard Graph Aggregated by Year and Month (in correct correct order)
Hi, I am really struggling with this. Like everyone, I have used Excel for years to report on data and it easily recognizes data that is categorized by year and month and displays it on a graph for trend analysis. I have used the MONTH and YEAR functions to extract the right values and used a summary report to gather the…
-
% Complete using Target Hours
How do I get the % Complete column to reflect the percent of Target Hours complete rather than the duration of days?
-
How to create a dashboard using data from multiple "task trackers"
Each of the projects managed by my group have a task tracker with uniform standard tasks as the backbone of the project life cycle. What would be the best way to roll all of these individual sheets, which each reside in different project folders in the same workspace, and display them in a graphical format for quick review…
-
COUNTIFS with OR
Hello I need help using a countifs formula with or for multiple entries. Here's the formula I have: =COUNTFIS({Sheet1 Range3}, "2024", {Sheet1 Range 1}, OR("Security1", Security2") I need it to count the number of Security 1 and Security2 entries for 2024 year. Its not working so far. Thanks
-
How to mimic Log scale graph in Smartsheet?
I am trying to create a graph for a dashboard where the # of projects is one bar and the total cost is a secondary bar. But the 3 of project is so much less it only shows as a number and no bar associated with the value. In Excel I can perform a Log scale to show the bar for the Total projects, any ideas for mimicking this…
-
When copying a row to another sheet, will all fields still transfer if a column is hidden?
-
How do I manage Unlicensed Admins and Editors user accounts
I am an admin on our Smartsheet account. When I open the Admin Center page and view the total users in our system, I see nearly 250 users listed as Unlicensed Admins and Editors. When I export the user type report I see that many of these accounts are no longer valid. I would like to "clean up" these accounts, removing…
-
What is the difference in the two Resource Management interfaces?
When in a sheet, I have access to the (limited) Resource Management interface accessed on the right side of the screen, but not the Resource Management interface marked with a nearly identical symbol on the left side of the screen. The one on the right seems to do what I need to review allocations and do some load…
-
Remove attachment and record the data
Hi is there any possibility to copy row to another sheet by removing the attachment
