Sign in to join the conversation:
I have a field - Let's say Closed Date
I am wanting a count of only those with close dates between 9/1/19 and 9/30/19. I keep trying different formulas but i keep getting the unparseable error
Try something like this...
=COUNTIFS([Closed Date]:[Closed Date], AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))
This will give you the count of all dates that fall within the month of September in 2019.
.
If you need to be able to specify the dates, you can try something like this...
=COUNTIFS([Closed Date]:[Closed Date], AND(@cell >= DATE(2019, 09, 01), @cell <= DATE(2019, 09, 30)))
Still looking for documentation, but I am curious about the limitations with the dropdown linking in Table View. Does a person need to have access to the dropdown source sheet in order for the dropdowns to populate on the Table sheet?
I want to add a calendar to my team's dashboard that shows both Anniversaries and Birthdays every year. I have the following columns: Team member Date (date of anniversary and birthday) Anniversary column to show this year's date (formula) Birthday column to show this year's date (formula) When I go into calendar mode, I…
I’m not sure if this has already been asked here or if there’s an existing Enhancement Request, but: is there any way to apply conditional formatting to multiple widgets in a dashboard at once? I have a large number of widgets, and applying conditional formatting individually to each one is very time‑consuming. Ideally,…
