Why do only some columns from sheet show up as dropdown options when creating a report?
When creating a new report, I select my sheet, then want to select the columns I need. However, Instead of all columns being listed in the Column drop down, I only see 4. Does anyone know why all columns would not show up or what I am doing incorrectly?
Answers
-
hi @SWojo this is a really od behaviour that I have not seen in my 7 year old work with Smartsheet that it only shows those system columns. Does it show it for all the sheets or only this one sheet?
Even if all the columns were formulas it should still show something.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
-
Hi,
I hope you're well and safe!
You selected the option to create a Sheet Summary Report instead of the Row Report option.Try creating a new Report and ensure you select the Row Report option.
Did that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I've made certain the workspace is shared, as sharing is one item I saw which could impact this. I tried to create a summary report today, and still have those system fields and no others. Kowal - it is any sheet I pull into the shared workspace.
-
Did you check the Report type?
Do you want to create a Sheet Summary Report or a Row Report?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Mystery solved. If I am in my workspaces (see all workspaces listed to left, "create" button top right, and Access in right bar, the report works. However, if I'm in the view which just shows my workspace and its contents, there is a new "+" button to add items, and it is this area that the reports do not work.
-
Can you share more information/screenshots to explain the situation more?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Well, mystery solved yesterday, but the route which worked yesterday now has the same issue. For Andree, this issue is for both the Row and Summary reports. I have redacted screen shots below which I submitted in a Case to Smartsheet this morning. Thank you for any inputs/thoughts.
-
Did this ever get solved? I am having the exact same issue. Any new reports I create I only get those 4 options, old reports work fine? I have a meeting tomorrow and need this ASAP. How do we address? The customer has said they hate tech like this because it never works right and I told them it will be the best tool to manage the job information. Egg on my face if I do fix this asap.
-
Hi @bmallon,
There's a few things that you can try:
1. Confirm that when you create a report, you're creating a "Row Report" instead of a "Sheet Summary Report".
2. Try to create Row Report from the "Workspaces" menu.
3. Try to create a Row Report from the "Browse" menu.
4. Try to create a Row Report from the "Create" menu.
If all of these reports still have this issue, where you can see all of the columns, then I recommend filing a ticket in the Support Portal.
I hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
