Sign in to join the conversation:
I have -
a column containing start dates, that spans 2019
a column containing an assortment of names that re-occur on a random basis.
I want to count how many times each name occurs each month.
Any help appreciated!
Hi Amanda,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Try something along the lines of...
=COUNTIFS([Name Column]:[Name Column], "Name", [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = ##)
Replace the column names with yours and replace the ## with the appropriate month number, and this should work.
Thank you!
Happy to help.
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
