-
Report not pulling formatting from source sheets
I can't seem to figure out why the formatting in place on the source sheets we are using are NOT pulling into some of the reports we've created. Works on some but not others. Everything I'm reading says that formatting in a report is based on the formatting in the source sheet. I've looked at other reports that are working…
-
How to add an Image into a cell in a Report
We have a single sheet broken into many reports that different users use during a process of development of a product. The sheet holds all the columns and is the single source of truth while the reports give snap shots of each step and only shows columns relevant to that step/user. My question: You can copy/paste an image…
-
Can the Calendar View display the sheet name instead of the primary column?
I'm creating a report that pulls in all of our Go-Live dates from all of our project plan sheets using a dynamic report in our control center. Is there a way to have the calendar view show the name of the project sheet instead of the primary column (in this case it's the task name in the project plan). So the way it…
-
Resource report gantt chart
Hello! I need to create a report to visualize resource utilization per project over time, similar to this: https://community.smartsheet.com/discussion/76598/how-do-you-track-parallel-projects-and-show-overlapping-resources Some important context: I do not have access to resource management or resource settings. All of my…
-
Reporting on Dates in the past for Milestones
Hello, I am trying to run a report for upcoming milestone dates for employees such as birthdates and hire date anniversary's. I have the format in a date cell in the Mon/Day/year format. When I run the report the "In the next xx of days" filter does not grab any of my dates as they are in the past. Is there a good way to…
-
Merged: Publish Reports for Editing
This discussion has been merged.
-
Sharing or Conversations, Attachments, Etc. side panels in the way? Temporary Fix.
I had a user at our company complain to me about the Sharing panel taking up too much real estate while on his laptop. He also expressed annoyance at being unable to hide the Conversations, Attachments, Etc. panel and having it stay hidden. I put together this simple Chrome Extension (works in the Edge browser too) that…
-
Creating a chart from a multi-select dropdown among multiple sheets?
Hi there, I am running into a roadblock on creating a report and graph for the below scenario. We have a bunch of event sheets (about 10) that all have an 'assigned to' column that is a multi-select contact list and it varies between sometimes being assigned to just one person and sometimes to multiple. I am trying to…
-
How to count cells when they have multiple values selected, and I'm only wanting a specific one?
Because we can't use wildcards on the program, I am at a loss to set up a report that summarizes my sheet. I'm trying to determine how many entries are the 'Status' outlined in each Primary Column row, where the 'Suggest Solution' is the text in each column header. The 'Status' can only be one value, but the 'Suggested…
-
Looking for Invoice tracker and/or Purchase Order tracking template
I inherited a sheet that I'm trying to redesign. We have multiple purchase orders (PO) with multiple invoices applied to each PO. Once an individual invoice is paid by accounting, we want to mark the row "complete" and move the row to an archive sheet. The PO needs to continue to reside on the original sheet so that…