-
Need to be able to organize summary sheet data for dashboard widgets
I have over 100 sheet summary data sets that I have nicely organized on the main smartsheet I'm pulling data from. However, when I try to set up widgets using the same data, there is no rhyme or reason to how they are organized. It's not even alphanumerical, so I have to go searching for all the matching sets. For example,…
-
Suggested Sheets - Update more frequently or in real tme
I notice when I update a sheet, and it appears on my suggested sheet, the preview is not updated. I was told that only occasional screen grabs are taken, and it looks like my sheet is not current, when in fact, it is, giving me problems with the boss.😫 I think the suggested sheets should be updated as well, in real time,…
-
Summary of Project and Phase Allocation % for each resource
I am trying to create a section at the top of the projects Gantt that shows the total allocation % for each resource in each project phase and in the project overall. I need this to not double count in resource manager, but just roll up each resource's allocation % from a Phase and the project in total. I've tried adding…
-
Formatting report data coming from Sheet Summaries
Hi, I have created a Sheet Summary Report which pulls data from the Summary tab of multiple source sheets. Nothing easier, right?? But, I can't see any way to center-justify the data in the report (because normally it grabs the justification from the source sheet column). Is there a command somewhere I'm just not seeing?…
-
How do I gather and display info for this dashboard widget?
Hello Everyone! I have a dashboard that is tracking the progress of several projects. My audience had requested a visual representation of where each project is in the PM Phases Initiation, Planning, Execution, Monitor and Control, Closure I have created a sheet summary report that shows in words where each is is but they…
-
SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…
-
When the CopySheet API responds, is the copied sheet really fully created?
I am synchronously using the CopySheet API to make a copy of a sheet. This API responds with a sheet summary, which itself includes the copied sheet's id. Immediately when that sheet is copied, I call the GetSheet API to get the full details of the new sheet. Mostly this works, but a moderate number of times, I will get a…
-
Smartsheet Summary Counting Assigned to with multiple people in the field.
I have the sheet below and I want to count for each person how may items are pending their approval. The formulas I have tried only find where it is only one person in the column. Where there are two people in the column it ignores the column. I have tried =COUNTIFS([Pending Approval From]:[Pending Approval From],…
-
Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
I have a date field for projected go live date for projects in my Sheet Summary. I would like to add another field with a formula that will display only the Month Name in another field so that when I run the Sheet Summary report I can summarize projects going live by month. I would appreciate any guidance!! Thank you!
-
Modern Reporting now available on Smartsheet Gov!
Hi Community, We’re excited to announce an improved, more intuitive way to create and update reports is coming to Smartsheet Gov. The new report builder makes it easier to understand, create, and update reports with an improved, more intuitive experience. Card view gives you quick and actionable insight into the status of…