-
Can i show the workspace a sheet is contained in on a report page
thanks
-
Why can't I merge data from 2 sheets onto 1
I'm trying to merge data from 2 sheets onto 1 sheet or even a report. I don't want to have duplicate rows w/ the same primary column though. I want all the data for the same Primary column value on each sheet to be merged into 1 row on the consolidated sheet/report. Why isn't this possible?
-
Combine dates from multiple sheets into one calendar
I have 3 sheets, one for marketing, one for sales calls, one for training. How can I combine the dates/items from each sheet onto a master, to create a master calendar that I can then export to ical and put into my outlook?
-
Can a Report Configuration ... "Include Parent Rows"?
Smartsheet has been a wonderful tool for my team since 2015. A couple things (out of many) I like are the quick sorting options on a sheet and the easy report configuration. With one nusiance exception, and I keep running into this ... On a sheet I can apply a filter and click on a box that will cause the inclusion of the…
-
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…
