I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
I have reports generated from a sheet where sheets attachments feature Google Docs/Smartsheet Merge Add On. I am not seeing the attachments in the report. Is this to be expected? Thank you! Lisa
Is it possible to parse out a contact field with multiple contacts into a report or new sheet listing each contact on its own row? If that is not possible, can you do the reverse? I hope this makes sense.
Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable. We've stopped…
Maybe I'm making this harder than it is but I can't figure out a way. I'm working towards ultimately building a Dashboard Chart (Pie Chart) based on Summary data from around 54 project schedules. I've created a Report that contains the information I need from the Summary information from each schedule (54 lines of summary…
The today line should be visible when a report is added to a dashboard in Gantt view. This is a very necessary reference point for a dashboard.
After adding two columns to a source sheet, my reports built over that file with filters on date columns stopped to recognize the date columns as date. The column in the original file still interprets the date column as date, but not on the reports built over it. Log off / Log in Remove / add the columns again. Recreate…
Hello, I need to create a report that shows me "installation complete" from around 88 pages, I tried so many different things, but I can't get to do it. It keeps showing me rows that I don't need. If you know, please help. Please see below; if you can see, it shows the site audit, but I need the "Installation crew…
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…
Hi there, We utilize Smartsheet reports for dozens of lists compiled from our master list of information. Those reports are then exported to PDF and the current problem is that the images needed for each row are not carried over to the exported report. Given the initial reason for limiting the export to 100 was back in…