-
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…
-
Merged: Allow for updating report parameters via API
This discussion has been merged.
-
Auto populate formula column not showing up on report
Hello! I have a sheet with a formula to auto populate a checkbox is a status is entered. The checkbox formula works on the sheet, but when I created a report to pull the checkbox column, the column is empty and will not show the checkbox. Did I do something wrong? Is there a way to populate the column in the report and…
-
Remove Column Headers in Report Widget
Report Widgets when using only 1 column are very difficult to design and integrate into a dashboard. You can either not have a title but then it does not match other widgets or use a title but then it basically has 2 titles. See below images. Without title: With Title: The option to remove the column headers would allow…
-
Impact of archiving on non-Dynamic Reports?
When I archive a project, what happens to any reports that are not set up as Dynamic Reports? Is there a way to automatically continue including them in those non-Dynamic Reports? I know you can retain archived projects in Dynamic Reports, but these do not fit that condition. Thanks for your help.
-
View parent (and child) rows in report?
Is there a way to view parent and child rows in a report? Asking as using the std project dashboard with 'At risk tasks' report (from the schedule). This surfaces rows where due date is in the past and status other than complete. However, for lengthy schedules it surfaces child rows that have no context when in a long list…
-
Checklist Report
Hello, In my smartsheet, I have something of a checklist with all checklist items on a new row. Each item is accompanied by about 5+ columns for "Checklist Item" "Complete?" "Due Date" "Close Date" "Notes" and so on. The checklist is to be duplicated for each new program we launch and contains 124 checklist items. Since we…