Having problems figuring out how to get a view like this.

shayden1

I have a chart that I use in excel but would like to build in Smartsheet. Does anyone have a how-to on building something like this? I have already built them all out in sheet summary.

SSFeatures

Hi @shayden1, instead of putting the values in Sheet Summary Fields, you can put the values directly in the cells.

For example:

I created columns named "Status", "IA", "IAKS", etc, and then I placed the values directly in here.

Then we can add the Ticket Count rows and columns like this:

For the horizontal Ticket Count, I used formulas like this:

=SUM(IA1:IA4)
=SUM(IAKS1:IAKS4)
=SUM(IAKSMO1:IAKSMO4)

These formulas SUM the cells 1-4 in each particular column.

For the vertical Ticket Count, I used this formula:

=SUM(IA@row:IAKSMO@row)

This formula sums all of the values in the row, starting at the IA column and going to the IAKSMO column.

I hope this helps!

Andrée Starå

https://community.smartsheet.com/discussion/139668/having-problems-figuring-out-how-to-get-a-view-like-this

Hi,

I hope you're well and safe!

Can you share some screenshots of what you have in Smartsheet already, and/or paste the formula(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution/help to answer! I appreciate it, thank you! 🙏

shayden1

SSFeatures

Hi @shayden1, instead of putting the values in Sheet Summary Fields, you can put the values directly in the cells.

For example:

I created columns named "Status", "IA", "IAKS", etc, and then I placed the values directly in here.

Then we can add the Ticket Count rows and columns like this:

For the horizontal Ticket Count, I used formulas like this:

=SUM(IA1:IA4)
=SUM(IAKS1:IAKS4)
=SUM(IAKSMO1:IAKSMO4)

These formulas SUM the cells 1-4 in each particular column.

For the vertical Ticket Count, I used this formula:

=SUM(IA@row:IAKSMO@row)

This formula sums all of the values in the row, starting at the IA column and going to the IAKSMO column.

I hope this helps!

Andrée Starå

https://community.smartsheet.com/discussion/comment/485327#Comment_485327

What Nathan said! 😉

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

shayden1

This is helpful, I will have to create them in a separate sheet since my current sheet has way more columns than this. Can you get this put into the dashboard then? Sorry, new to dashboards and just trying to learn the best way to handle different builds.

SSFeatures

@shayden1 Glad it's helpful!

You can definitely add this data into a dashboard. For example, I made a chart with the Ticket Counts for each column here:

The way that I did this was by clicking here:

You can create charts and graphs, or you could directly embed the data in the dashboard if you wanted. There's a lot that you can do with this data!

Best!