-
Sheet Name links not taking user to correct sheet row
Hi there, since yesterday I have noticed that the Sheet Name column links in reports are not taking the user the correct row in the source sheet, as they have always done. There does not seem to be a pattern, sometimes it takes the report user to the top of the source sheet, or to a random row, or the odd time to the…
-
Combining data from 3 different columns to create a summary report
Hi all. I am trying to create a summary repot that combines 3 columns that I have on an Intake Sheet and Archive sheet. The data that is in each of these columns are pretty much the same, but we have them separated out based upon on the different clients that we have. Within these 3 columns, it has Job type data (i.e.…
-
Text Wrapping on Report Group Headings
It would be very helpful to have text wrapping on the headings that appear when you 'group by' on reports. In our case, we group some reports by project name as this is most intuitive for the users of the reports. These project names can often be several words long, and it looks really untidy when half the project name…
-
Possible Bug? Budget Report Excluding Current Week (Unapproved) Hours
I’m seeing what appears to be a gap in the standard Budget Report within RM and would like to confirm whether this is expected behavior or a defect. When viewing a project and running the out-of-the-box Budget Report from the left sidebar, it uses the default filters: Entry Type: Future, Confirmed Approval Status:…
-
Daily Automations
Are automations set to daily, based on only EOD data or compile all the triggers and send together at EOD? I'm looking for only EOD data and now sure how to get only that in my sheet.
-
Weekly/Monthly Status Reports
Hello smarties! I hope you all are doing well. I have a new situation that I wanted to start with you all to see how you would handle. I have a new situation where we need to supply a Weekly/Monthly Status Report. I know that I could build this in a dashboard (I also plan to do this) however is there a way to "save" or…
-
Fields displayed in Timeline View - Reports
We're trying to use Timeline view in Reports and so far it's working great, however, we're unable to change the Fields that are displayed when you hover over the item. I've found this article/question from last year, and this seems to be the same problem that we are facing Discussion 141807 When we go to our sheet (that…
-
Reports - How do I add a specific cell from every sheet
I have a workspace that has several sheets and I want to create a Report that shows me the cell Column5 row 6 from each of those sheet, and if the content of that cell is equal to a specific content, then i want that sheet to be on the report. After that I want to add Column6 row 3 to the report from every sheet that met…
-
Smartsheet Solution - Dynamic Configurations
We are trying to develop a Smartsheet solution to replace an Excel file that is bursting at the seams and is running slowly due to the number of columns and rows. The existing Excel spreadsheets break down configurations, determining the number of units based on total volume and percentage. The ultimate desired end state…
-
Creating a summary for a workspace
I have a workspace that has a revolving set of sheets. Some of the sheets are active for the time being but are not active now. There are several cells that I would like to have on the summary , like the client name, the status of the sheet, the date expected to go live, health of the sheet. What would be the best tool to…