-
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…
-
Reports column problem
Hello, I have added a column that is a dropdown list allowing multiple values per cell. It shows up and works in the main sheet, however, the report will not show the options. What is going on??
-
Update Request Links
Hi - I'm wondering if there's any way to capture the actual Update Request link (what comes through in the email when you send the Update Request) in a report? Our account people get tons of Update Requests, and don't always have the info to follow up immediately. So, rather than have to sift through emails, is there an…
