Sign in to join the conversation:
Hello,
I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names?
Many thanks,
Pltrmgrl
@Paul Newcome I tried this and it is saying incorrect argument set. Let me know your thoughts
@alexandromeda You have a misplaced closing parenthesis that needs moved from the very end to close out the COUNTIFS.
@Paul Newcome
hi Paul,
Your first formula worked great for me as well!
the only thing is im not able to do is convert it into a column formula, i get the "sintaxis isnt quite right" message.
do you know if there is a way to use it as a column formula?
@artrubio Exactly which formula are you using?
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
