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.
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
