-
How to Concatenate multiple cells into a single cell within a VLOOKUP formula?
I've created a VLOOKUP formula to pull in data from a source smartsheet, into a 'staging' smartsheet but, if more than one row match the criteria, only the first row entered in the source smartsheet get entered into the cell on the 'staging' smartsheet. For instance, I'm looking for entries on the source smartsheet that…
-
Product Suggestion - Admin Issues
This popped into my head as we have one of our licensed users who just refuses to share anything with any of us. What happens if they create a lot of important sheets that contain data and part ways with the company, how do we access this? The Super Admin should automatically have the ability to have access or a backup to…
-
Dashboard: Loss of images that existed on my report
In our Smartsheet set up, we provide photos of users that appear with their name (in assigned tos, owners, etc). These photos will appear in sheets, reports, etc. However, when we use a given report or data source in a dashboard, the image/photo is removed. Is this a known issue or is there a setting/checkbox we need to…
-
Building a Dashboard from a Report
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build a metric sheet to create my Dash based upon that report?
-
Pinned Sheets, Manual ordering Feature
Hi, Just a small feature request. It would be nice to be able to manually order my pinned sheets (drag and drop) in the recently opened left-hand side menu. I have about 30 sheets pinned which i regularly use. Cheers, Ritchie
-
Printing Dashboards loses all the color
I have a very nice dashboard created with lots of color separators to make it east to read. But when I print it, all the color goes away and the fields I created are not showing up. Why is that?
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
Notification Options when Saving as New
Is there a way to have all the Notification & Sharing Options checkboxes when saving as new? Is there a setting that can be 'turned on' to do this?
-
Can you assign muliple resources to a task without duplicating the row?
Currently, I am having to list the same task on muliple rows to assign different resources to them. Is there a way to assign mulitple resources to the same task without having to duplicate the tasks over and over again? There is a lot of repetitive content that is doubling the size of my Smartsheet.
-
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
