-
Can not do simple math caluculations in report field
When using reports, the fields are not calculating simple math equations. Any ideas.
-
Change Order of Sheets in Report
I have two sheets that show data from two different fiscal years: * [FY 2019] Course Development Tracker * [FY 2020] Course Development Tracker I added both of these to the Report Builder, but I want the data in [FY 2020] Course Development Tracker to appear above the data in [FY 2019] Course Development Tracker. I thought…
-
Report Not Updating
Hi everyone, I have a report that is not updating to show a newly added row. The origin sheet has been saved and refreshed. There is no criteria listed on the report that would affect the data to be shown. I'm new to Smartsheet user forms, so I'm not sure if my report is somehow affected by the form or reference sheet.…
-
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