-
Report by user: Filter empty for only one user
Hi, I have created a report by user and it works fine for all users of my sheet with the exception of one user. The field that I have marked in yellow below is showing empty for this one user and therefore not pulling the data for her, she only gets a blank sheet. How can I fix this? Thank you! Christine
-
Report Question
Greetings, I am sure this is a no brainer question and I did try a search. Also, I am rusty, it's been awhile, apologies. In a row report, I am pulling data from the "Mother of all Sheets" were everything is stored. We interact with this sheet using extreme care. In my Row report, I can can sort and group moving where the…
-
Sorting in a report
I am filtering information on a report by Start Date in between Jan 1 and Dec 31 of 2022, start date is in the future, and in the next 120 days. Grouping it by month (January - December). This is populated by a helper column formula that takes the month from the start date and converts to the month. I am grouping the…
-
Creating Calculated Column in Report (Formula Column)
Dear Smart Community, I looking for the calculating column in the report instead of creating new column in the Source file. I have 7 level of approval and want to know the approval period in this case I have to create 7 new column in the source file instead of this is there any option to create calculated column in the…
-
Parsing Text into Child Rows
Good morning. I am running the Jira Integration, and I would like to create a view or report that lists linked issues (in the 3rd column from the screenshot) as child rows. The text will always be in the format ("includes OR-X") but I have several problems parsing the text. The key number (ex: 2437) could have up to 6…
-
How to use project status report and templates
Hi, I'm still new to ss and how to use free downloads! I'm stuck on how to use the Weekly Project Status Report Template like its shown in the image marked "report layout". I downloaded the template to which I have to complete the data (ref. image- "template layout". The issue is that I'm missing a key step to convert the…
-
Formula to count rows in a report
On a sheet, is there a way to write a formula to count how many rows are on a report. We have many reports and would like to know how may rows are in each report on a single sheet.
-
Icon sets, driven by formula column, are not showing correctly in reports.
I have set up two icon set columns in my sheet. For both columns, I'm using a (different) formula to drive which icon is displayed. Both columns work fine and display correctly in the sheet. However, when pulling these columns into a report, one of them is not displaying the icons correctly. The column labeled "health"…
-
Multi-Sheet Cap for Reports/Pivots/Dashboards
Good morning, I need to report on data spread over 50+ sheets that are updated independently. The plan had been to place all these sheets in a single workspace and run a Dashboard or a Pivot referencing them all, but I cannot find whether there is a limit on the number of sheets a single Dashboard or Pivot can reference.…
-
Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…