-
Automatically update current stage
Hi, I am trying to track progress through various stages of publication (the columns titled approval, data collection, analysis...accepted). I thought the health bubbles may be a good way to quickly visualize progress but it is confusing the card view as it can only organize per specified column at a time. What would be…
-
Find most recent updated status for category
Hi all, I'm searching for a solution on following idea: I have a sheet with following four columns: Created (date) | Category (Dropdown) | Previous Status (RYG balls) | Current Status (RYG balls) Now I want to auto-populate "Previous Status" with the last "Current Status" of the same "Category" when a new row is entered.…
-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Smartsheet chart reneame "the source data for this chart has been changed"
Hi, Is there a way to reneame the error message Smartsheet charts show ("the source data for this chart has been changed") when there is no data in the underlying report it's being driven from? I have set up my charts in such a way that once data is added for the future months, those charts for the future months will also…
-
Is there a way or alternative way in referencing a formula from the Report?
Hi, I have a huge data in my sheet which is automatically fetching data from a google sheet. And to summarize my data to which I need, I am planning to use a Report but when I am computing for a COUNTIF, I have realized that the we can't reference a formula from the Report yet. Is there a new feature to convert Report into…
-
Running a report with multiple sheets, columns not populating
Hello, I am attempting to run a report with multiple sheets and/or a workspace (I have tried it both ways) the criteria seems to work fine but when I attempt to show a column from one of the other worksheets it does not populate. Any suggestions??
-
Use Metric Widget to Show User Selectable Single Row
I want to be able to display the data from a single row on a dashboard (see image), but I want the user to be able to select which row to display from the rows available to them. Can this be done with a metric widget or some other method? tx DJ
-
Combining multiple views of a project plan in one
In our previous solution, we had five project plans for users to choose from. This caused reporting issues as our milestones did not align between project plans. Has anyone combined project plans into one template and allowed the user to see the appropriate tasks for their chosen project plan by perhaps a filter? Example,…
-
Using reports (or other methods) to update sheet - security question
Hi there, I'm fairly new to Upwork. I have worked through a lot of the training material, but I haven't yet covered it all, and I also lack experience. I have a Sheet with a large amount of client data on it, some of this info is sensitive. I want to ask several staff members to make contact with each client, then update a…
-
Add Pivot report/table to dashboard?
Hi there, I've created a report using Pivot that shows all the budget types and the amounts for them as well as the overall total amount spent. I don't want to show this data in table form, but I seem to be unable to select a Pivot report using the Report dashboard widget. How can I show the Pivot table/report itself in a…