Sheet Summary fields not showing all data on Report

Options

Please see the image. For some reason some sheet summary fields are not displaying on the report and others are. All are visible when I view the fields from the report. I've tried moving the sheet to a different workspace and folder, changed the values in the fields, etc., nothing works.


Why are the green showing just fine and the yellow highlights aren't? ?


Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @jlee579

    The way reports work to add Columns, if the column on one sheet is a Dropdown type column and on another sheet it's a date type column then it will show the columns as two separate ones instead of combining the data into the same column.

    Could it be that the sheet summary report is doing the same type of thing? What I mean is, it looks like the Sheet Summaries are all formulas. Is it possible that the Status, Solution, Sales Lead, etc columns which aren't coming in for Row 5 is because the formula in Status, Solution, Sales Lead etc for the sheets feeding Rows 1-4 are all the exact same formula but this sheet which is feeding Row 5 has a different formula in those cells than the other sheets?

    I'm grasping here but I can totally see SmartSheet doing the above thing.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @jlee579

    The way reports work to add Columns, if the column on one sheet is a Dropdown type column and on another sheet it's a date type column then it will show the columns as two separate ones instead of combining the data into the same column.

    Could it be that the sheet summary report is doing the same type of thing? What I mean is, it looks like the Sheet Summaries are all formulas. Is it possible that the Status, Solution, Sales Lead, etc columns which aren't coming in for Row 5 is because the formula in Status, Solution, Sales Lead etc for the sheets feeding Rows 1-4 are all the exact same formula but this sheet which is feeding Row 5 has a different formula in those cells than the other sheets?

    I'm grasping here but I can totally see SmartSheet doing the above thing.

  • jlee579
    jlee579 ✭✭✭
    Options

    You were correct. I didn't realize that some of the summary fields were text and a few were drop-down. For some reason it couldn't display the text on the report though at that point it's just text. Thanks!

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @jlee579

    Glad that helped to point you in the right direction. I'm not sure why it didn't put those Sheet Summaries into a new Column with the same name like it does on Grid sheet reports. If it were to do that it might have pointed you in the right direction just seeing it do that. SmartSheet is really odd sometimes and inconsistent in how it acts.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!