Best Of
Re: Formula Multiple Parameters with Multi-Sheet Reference
Ok. So there is a difference between your formula and your filter. Your formula is looking for January regardless of the year, but your filter is looking between specific dates. Is there an entry for January 2024?
Paul Newcome
Re: Count Formula
@DKazatsky2 Yes, I want to count the number of times! your formula worked! Thank you!!
I must say that I have not used the @cell like that. Is the @cell referring tothe "Client name (pruning)?
Craig Lemberger
Re: How do I trigger an alert if the date in the End Date column is NOT the last day of the month?
As per Paul's comment on another post;
The easiest way to get the last day of the month is to get the first day of the next month and then subtract 1.
=IFERROR(DATE(YEAR([Date Column]@row), MONTH([Date Column]@row) + 1, 1), DATE(YEAR([Date Column]@row) + 1, 1, 1)) - 1
You can use that formula as a column formula in a helper column that you can keep hidden.
Hope that helps!
BRgds,
-Ray
Ray Lindstrom
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
Re: Count Formula
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
Re: Return All Values based on a Filter
This is awesome!!
I wish Smartsheet would make a few edits like array formula flows and conditional formatting for "duplicate values".
Pestomania
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.
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
Georgie
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?
State | 3 |
|---|---|
Federal | 3 |
Community | 4 |
markkrebs
Re: Creating a list based on checkbox columns
Here is an article that should help get you started:
.
Paul Newcome