Hi All, I am attempting to generate a report off of a filter criteria in the main sheet. It is is a live document and we work off specific filter criteria's per person, but I want to generate a report based off the circled "Current Renewals" only, but when I go to to generate the report, the report takes all historical…
I have a dashboard chart widget whose source data is a report on a sheet. There are times when the report accurately returns no data from the sheet that meets the reporting filter criteria. In that case, the dashboard chart widget displays an 'Unable to display chart' error (screenshot below). This error message is…
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
Allow users to export a report from a WorkApp
Can a report be directly exported from a WorkApp?
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…
Hey all. This is likely a stupid question that has been answered before. None of the searches I have done have had quite the answer I was looking for. I am working my way through the core app learning path, but I haven't found what I am looking for. There are what feel like hints of it, but nothing that has clicked for me.…
I have 5 different sheets representing 5 different projects in 1 program of work. So I am creating reports to bring those 5 sheets together to get a program level view. For one report, I want to see timings in a gantt view and color the bars based on the project sheet. However, I can't do this without changing the…
Hi. I am linking a report to a Dynamic View. however, I want to be able to preserve the report groupings in Dynamic View. How can I do that? Thanks
Hello, I have 9 identical sheets (obviously data within them differs) for 40 clients that I'd like to aggregate. The clients fall under 3 verticals and those 3 verticals roll up to one division. I have trying to aggregate the data through cross references but somehow have maxed that out (maybe I am approaching wrong?).…