-
Why do reports change column name for Modified by and Modified columns?
I have multiple sheets I'm rolling up into a report. Each sheet has a "Modified by" and "Modified" column, except I've renamed them (in every sheet) to "modified_by" and "modified_date". However, when I create the report, it only let's me select "Modified by" and "Modified" as the column names. Why? Does anyone know a…
-
Merged: Sheet Name URL in DV
This discussion has been merged.
-
Grouping in reports is gone when sending it via email as excel spreadsheet?
I made a report and grouped values in the report. When sending it via email as an excel spreadsheet, I get raw excel file, with no grouping/filters applied. Any ideas?
-
templates
I recently created a project from the templates provided - the 'Ticketing system' one. How would I go about changing the 'duration' column from days to hours? We report on an hourly basis for our projects but it's a locked field and when I edit it, it doesn't give me the option to change the type. Thanks in advance!
-
Open Sheet in New Tab When Select Hyperlink in Report
I would like to be able to open my linked sheet in a new window when I select the hyperlink from a report. I have very lengthy reports that pull in hundreds of sheets. When reviewing data, I'll expand and collapse grouped data as I work my way down the report. I occassionally need to navigate to the underlying sheet to…
-
How to create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
-
Merged: Detailed interactive chart widgets
This discussion has been merged.
-
Merged: Report Column Header Color
This discussion has been merged.
-
Row Report - Displayed Sheet Names Do Not Update
I have several (OK, 10+) Smartsheets in a workspace and have put together a row report which filters and only displays the open tasks for each Smartsheet based on the column information. Simple enough. My problem is that will update the individual Smartsheet names to allow for easier sorting, however this takes an…
-
URL Query report options
Create query endpoints for reports so a link can auto filter a sheet when the URL is clicked to do certain things. This would make it much easier to manage reports for weekly/monthly/quarterly, and many other things. In my use case, this would simplify how many separate reports are needed. Below is an example of what could…