-
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…
-
Is it possible to use Group information in Smartsheet Reports?
Hi Is it possible to access the Group that a resource in the 'Assigned To' column is a member of, in Smartsheet Reports, eg like doing a VLOOKUP on the resource name? Many thanks. Nigel
-
Reports using HOURS past Creation Date/Time Criteria
Hello friends, I need to be able to create a REPORT where the only rows that appear are those that are equal to or greater than 3 hours past the Creation Date/Time. Is this possible?
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
No matching rows found when I try to create a report
Yesterday I asked, and David Tutwiler answered, how to locate the "create reports" section. This was helpful and I created a report. When I press "run" it says "no rows found." A coworker said I don't have a license and that is why? Please let me know. I can do many other things I was told individuals with licenses can't.
