-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
-
Overlapping Labels on Bar Charts
I am using a stacked bar graph in order to show a breakdown of projected costs and where they come from. However, when using Data Labels, the totals and highest portion overlap. So far I have not been able to find a way to move labels around at all. I am specifically looking for a way to see the summed totals per month,…
-
"contains" logic in Report Builder to include "and" instead of just "or"
I'm building a report using the "contains" logic on the Primary field called "Task Name". I'd like the report to return the rows whose Task Name includes the words "Phase" AND "Review". I cannot figure out how to execute this logic as it defaults to including rows whose Task Name include the words "Phase" OR "Review". This…
-
"contains" logic in report builder returns rows that don't include the specific text
I'm building a report where I would like the report to include rows whose primary column includes the text "ORR". The report includes rows that I want, but also includes rows that include the word "correction" because that word includes the same string of characters. Is there a way to limit it so that rows with only that…
-
Is there a way to pull only the children into the report?
I am trying to have a report that shows only the lowest indented children in it. I am working on a sheet that has 4 level of indents. Workstream (indent 0), Project (indent 1), Milestone (indent 2) and Activities (indent 3). The report needs to include activities only and not any of its parents. Please let me know if there…
-
Sheet Connection
scope: I have several states working and adding every day into smartsheet sheets, those sheets are required to be seen / reviewed by the state managers, out of this information I want to create a daily updated sheet from this on a master sheet for CEO level. Client requirement: to see an overall update daily with the new…
-
Bring Back REPORTS in the Menu!
Good morning, I am an avid Smartsheet license holder. But I am quite frustrated that the "Reports" option has been removed from the sidebar. For our work situation, I am in reports more often than I am in the sheet, so having this option restored would be of great value. I literally have over 100 reports and trying to…
-
INDEX and MATCH help
Hello, I am building a dashboard to pull information off multiple sheets, and have created a separate "config" sheet to use formulas and organize the information to make widgets easier. I am looking to pull info from a date column in a project plan, based on a unique task name. I have a column in the config sheet that…
-
Summary Report not displaying additional columns
I'm trying to create Summary Reports but only ever receive the created date/name, modified date/name and sheet name columns to select from to add to the report. I've tried saving and going back in but no luck. The sheets I'm selecting all have the same column names as they were duplicated with the save as new function.…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…