-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
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.