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've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
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,…
