Best Of
Re: Creating an automation workflow with multiple conditions to populate Size column
You would create a table in a second sheet that looks just like your first screenshot then use something along the lines of
=JOIN(COLLECT({Table Sheet Size Column}, {Table Sheet Outlet Column}, HAS([Social Outlet(s)]@row, @cell), CHAR(10))
Paul Newcome
Re: Community Corner Newsletter [May 2025]
Hello! Yes, Spring has Sprung! I moved to California 2 years ago from Michigan, so Spring starts earlier here. So amazing. I am not sure I am cut out for cold any more!
Welcome to all of the new Community Members!
I really like table view, and since it is relatively new still, I am still learning, and growing with it. Excited to see where it leads!
Happy May, Everyone!
Paul.Woodward
Re: How to change invitation email to new smartsheet users
I am not able to edit that email either. I went into Branding and Personalization and cannot see it.
Paul.Woodward
Re: Flagging "first occurrence" & "duplicate" as a column formula to identify unique values.
Hi @Michelle Choate 2 , thanks for your help! If I am following correctly, the syntax you mean is this?
=IF(COUNTIF([File Number]:[File Number], [File Number]@row) = 1, "First Occurrence", IF(COUNTIF([File Number]:[File Number], [File Number]@row) > 1, "Duplicate", ""))
I tried this, and although it works as a column formula, it still incorrectly flags the first occurrence as a "duplicate" for any risk file number that appears again in the column
Dave Werwinski
Re: Changing the UI language > does not seem to work
Actually I found out what the issue was: if you create a sheet and change the language settings afterwards, the change only applies to the main interface of Smartsheet but not at the lowest level, the sheet itself.
Edouard Albert
Re: How to pull a single instance of duplicates into another sheet?
Hi @shrobert ,
The easiest way to do this is to use an index(collect()). You create an index of the collected values and specify that you just wanted the first instance in the index.
=INDEX(COLLECT({Concat Column reference}, {Year Col Reference}, =[Column2]1, {Program Column Reference}, =[Column1]2 ), 1)
This collects anything in the Concat column on the other sheet by comparing the reference to the year column on the other sheet with the year in the first field of column 2 and the Program (Reading, Literature, etc.) with the program you have in Column 1. The 1 in the column specifies you only want the first instance. I believe you can drag this formula down to Literature and Math and across to column 3 to get 2023 as well.
ericncarr
Re: Please let Smartsheet work with time
I would love a time Column so that we can do a Start Time and an End time and use the Gant view to look at how long in time things take. Not just in Dates. This would make our use of Smartsheet way better then it already is. as we use time in our functions and we have to use Powerbi in order to make the Gant view work for us. it would be so amazing if we could use the smartsheet for that view. Also in the calendar app as well. then we can see things by date and people. I would be willing to talk to someone about this and show you what we are using it for.
Lisa_A_MWN
Re: Welcome to the Project Management Office (PMO) Community!
For a project manager in a world of donuts and coffee, Smartsheet is a lifesaver for tracking and planning remodels. All the data is organized ans easily accessible for our tream, even on an Iphone. I`m always seeking ways to improve, and it would be nice to connect with a community of like-minded professionals.
Olena
Re: Sheet Reference Manager panel - drag to expand the window
Problem: The "Sheet Reference Manager" cuts off sheet reference names that are more than 19 characters (at least on my screen).
Idea: Allow resizing of the name column so we can view the whole sheet reference name, instead of having to press "Edit" and wait a long time for it to load.
NeilKY
Re: Ability to paste a screenshot directly into Conversations > Comments or Attachments
If we are unable to copy-paste images/screenshots into the conversations, we are losing out! It is cumbersome to download every file, every time it needs to be accessed.
Rakshit