-
Scatter Graph: Plotting Value x Effort
Hi Smartsheet Community, My organization has a few questions about scatter graphs. Our goal is to create a graph that charts the organization’s projects according to value and effort on the X and Y axis. Here is an example of the format we want to create in PowerPoint. Of course, it would be much better in Smartsheet…
-
Calculate a date based on the status of another column drop down
Hi, I thought I was getting closer to figuring this one out but hit a wall! I have one column that has a dropdown menu. When one of two choices is selected, I want to calcuate a due date based upon the date a report was finalized. I'm adding a screenshot so hopefully this makes more sense. So when Initial Evaluation…
-
How do I join specific cells from multiple sheets?
The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potentially others, but I'm struggling with making it work the way I want it to. This is what I have: This sheet will be duplicated…
-
System Admins to change user permissions across the board
Please allow system admins the ability to change user permissions for a person across the board. You are implementing a new pricing model and I cannot effectively audit my users because this basic feature is not available. For example. I have Unlicensed editors with their activity being 60+ days that need to be viewers. I…
-
I am trying to show number of days vs the date posted in a dashbord
Hello amazing smartsheet community. I have created a report that shows number of days something was posted (duration column) vs the date it was originally posted. When I try to graph it within a dashboard it says the data isn't available. Am I not able to graph based on chronological order? Thanks Tracy
-
Changing user permissions across the entire platform
As Smartsheets moves to the new pricing model, I'm currently doing an audit of our users. I may be having blonde moment, but as a system admin, is there a way to change someone's permission level across the platform to Viewer? Some of our Unlicensed editors haven't been active in there for 3+ months and need a permission…
-
Resource Management analytics report showing phase dates
How do I run a Resource Management analytics report to show phase dates? It only seems to show the total project dates.
-
Update Request using a Form
I am creating a SmartSheet that we will load specific rows to it. I then would alert the contact of their row via Alert Someone workflow. Then the person would have to update a couple of columns/fields in the Smartsheet. Here is my problem: The Update feature doesn't give you an option (that I know of) of formatting the…
-
Upcoming Smartsheet User Groups - Sign up today!
📢 Attention Smartsheet Community members - We're excited to invite you to join us at our upcoming in-person and virtual User Groups! These sessions offer you a chance to network with other Smartsheet users, learn from their journeys, and acquire helpful strategies for getting the most out of the platform. Best of all,…
-
Mixed Fraction Formula
I am trying to get a cell to read 12 3/4 as 12.75 so Smartsheet will complete the math for the sheet in another cell.
