-
Group by function in reports
Does anyone know when Group-by in reports will be supported? If I remember correctly, it should be in this year (2018). Thanks for your advice!
-
Chart Widget -> Series tab not recognizing columns with a value of zero
In the Chart Widget, under the Series tab, is there a way to get Smartsheet to recognize columns that currently have a value of zero? I need to do this to lock in the colors of those columns, and you can't choose the color of the column when the value of that column happens to be zero.
-
Counting number of submissions and various stages
Hi I'm new to Smartsheet and trying to figure out ways it can help me keep track of the work we have ongoing in the department. At the moment I have an excel spreadsheet where I enter every new submission to we make to an outside authority, a new line when it is validated and then another when it has been approved. My boss…
-
Dark Mode feature need
How can we get a dark mode feature into the pipeline? It's very common these days for reports and forms to throttle between regular and dark mode. Hope this can be done easily to stay up to date.
-
Metric Widget Column Header
I am trying to grab data from my dashboard metrics sheet in such a way that data is associated with the selected column header, as opposed to the actual column header. I am trying to use the Metric Widget like how I use the Chart Widget, but am getting results like in the screenshot, attached, where the heading I am…
-
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…
-
How to determine how close I am to linking limits
Hi all, Is there a reasonable way to know if I'm getting close to the cross sheet link limits? Thanks, Darrell
-
Report Features
Hi, may I know can I add any bar or pie chart and customize the design of the smart sheet report just like the widget in the dashboard? Thank you.
-
Reports
Hi, Recently I create an report file, where I want him to show certain columns. I choose for "Where" condition the location from where i want him to extract the info. But if i will create another new sheet in that folder, even the entire folder is choosen for report, he dosn/t know to automatic include that new sheet in my…
-
Link a summary sheet to multiple workplans
I'd like to be able to link to fields in a separate worksheet based on certain criteria. I'll give an example to try and explain: I have multiple projects running concurrently; each has a separate project plan as they are shared with different stakeholders. Each project plan has an overall RYGB status, based on the 'worst'…
