Best Of

Re: Can a Viewer interact with a Dashboard?

Thanks @Kerry St. Thomas

I knew there would be a way….. I'm up and running…. thanks again, especially for the prompt response 😎

JamesS

1 ·

Re: Count Formula

@Craig Lemberger,

Is it that you won't every box name, even when repeated? Try with the DISTINCT removed.

=IF(COUNTIF({Client Name(Pruning Data)}, @cell = [Client Name]@row) = 0, "", COUNT(COLLECT({Box Name}, {Client Name(Pruning Data)}, @cell = [Client Name]@row)))

DKazatsky2

1 ·

Re: Return All Values based on a Filter

https://community.smartsheet.com/discussion/comment/470931#Comment_470931

This is awesome!!

I wish Smartsheet would make a few edits like array formula flows and conditional formatting for "duplicate values".

Pestomania

1 ·

Re: Metrics not matching Dashboard

Sounds good, Georgie - Yes, I have tried the suggestion and now I'm waiting to see if it behaves the same way it was behaving the past couple of days but thank you for your help! I'll be sure to open that ticket if need be, thanks again!

Amelia P.

2 ·

Re: Metrics not matching Dashboard

Hi @Amelia P.,

Have you tried deleting and recreating the formulas that are showing the incorrect values from the dashboard? I would attempt this, then save the sheet and then open the dashboard in the same browser tab.

If that doesn’t resolve the issue, the best next step would be to open a ticket with our Support team so they can take a look at this specific sheet and dashboard and communicate with you via private channels. If you open a ticket, please provide them with these screenshots as well as the IDs of the sheet and dashboard (open the item and click File > Properties to find the ID).

Thanks,

Georgie

1 ·

Re: Pie Chart using aggregation and words in one of the columns

So I made a pie chart off of this data: to get the counts you can use a report and do a summary on the "type" OR you can use a countif formula. Do you need assistance with creating either of those?