-
% 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
-
Data Shuttles aren't processing on upload
I can process them by clicking RUN, but they won't process on upload. Any ideas on why?
-
Posting to smartsheet using Postman
I'm trying to use postman to pull in some manpower logs from Procore and post these as a new row to a smartsheet. the results are pulling in correctly from Procore, and i have correct sheet and column IDs etc but nothing is posting onto the sheet - it just adds a blank row…. - the raw response i get is as below {…
