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.
Hi All, I need some help. I need a formula for sum of values within one column but I need to count it based on completion date. For context I want to messure how many labels were completed withing Q1, Q2, Q3 and Q4 2026. In my sheet is column with total amount of labels per change and another column has a date of…
Smartsheet is currently combining my automated emails from multiple lines into a single email. Is there a way to force each line to get its own email? I have column placeholders in the subject and body of the message, but it always combines lines into a single email when the automations are triggered at the same time for…
I've rebuilt my form at least five times and for the life of me cannot figure out why it will not trigger. I've tried to test and run it several times to no avail. Any tips would be very helpful. I was able to successfully trigger once, now nothing at all for a week.
