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?
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Hello, I face one difficulty trying to transform text in date using DATE formula I want to find the first day of a week based on the week number & year number put in a cell For instance in a cell I find "25-45" FOR Year= 2025 & Week= 45, so I look for the monday of this week that should be the 3rd of nov Step 1 find first…
I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is =IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row ))) but instead of returning the value it says #INVALID COLUMN VALUE Got it working…
