-
Any workaround for Primary column being the first column in a grouped report?
I actually feel a little silly even asking this, but I have a user request to do move a couple of columns to the left of the primary column in a report that uses Groups. Unfortunately I do not have a great response and I hope the collective awesomeness of the Smartsheet community has a better answer than "I can't make the…
-
How do I create a report that displays rows that are passed a certain set date for each row?
I'm attempting to create a report that easily displays rows that are delayed. For example, if I had a planned delivery date of 08/07/2024 (UK Format), but this was actually delivered on 10/07/2024 (UK Format), I would like the report to only display this row. If the planned delivery date of 08/07/2024 (UK Format) was met,…
-
Report columns from 2 sheets to appear side by side
I have a report that pulls several columns from two sheets. By default, the rows from 2nd sheet appear below the rows from 1st sheet. But I want the rows from 2nd sheet to appear to the right of the rows from the first sheet. Is this doable in Smartsheet? And, what if the number of columns I need both the sheets are not…
-
Smartsheet report issue
Hello Everyone, I am observing some strange issues in Reports, so we have this workspace and I have selected the entire workspace, to get the filtered data. I can see most of the sheets but am not able to see a few sheets in my filtered report, on the other hand, my team members who created all the sheets, reports can see…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Accessibility for report
Hi, I'm trying to assess the level of accessibility support for reports. I can tab through the published report but when there's a link in a cell (which you can launch by clicking on it with the mouse), I can't seem to launch it in any way. Normally, it is Space or Enter. Neither works. Can someone tell me how to launch a…
-
Charts - reporting on two 'Counts'
Hi, My company is logging Fire Risk Assessment actions, and we want to see a chart that shows: Actions by priority and then within that: Actions by 'complete'. So, for example, we want to see that there are 46 Minor actions, 19 of which are 'complete' (a checkbox), 144 Moderate actions, 130 of which are 'complete', etc. At…
-
Display different report based on day of week in dashboard widget
Hello all, New user here. I am building an updated dashboard for my job and I was wondering if there is a workflow that will allow a report widget to display a different report depending on the day of the week? I have used other examples here in the community to add a widget that displays the days date and day of the week……
-
Automating Monthly Generation of Multiple Reports
Hello Smartsheeters! I have 14 reports that pull data from a master sheet that we need to report to an Important Entity each month. I'm hoping I can get out of the routine I have now, which is to save the batch of the prior month's reports as new and manually update the date parameters and the title for all 14 reports. For…
-
Why does it take a long time for my report to update its alphabetical order after I rename sheets?
I have a report that I'd like to appear alphabetically. When I update the names of my sheets to reflect 1, 2, 3, etc based on the order I want them to appear, the report doesn't update sometimes until days later. Is there something else I should be doing besides refreshing, signing in, signing out, etc to get this…