Best Of
Re: How to hide attachments and Comments in Reports within WorkApps
I have the exact same problem. Dynamic View appears to be extortionate for a very very basic purpose that Smartsheet almost fulfills but the attachments cannot be hidden no matter what you do.
I am open to creating a workaround mirror sheet without attachments and also hiding certain columns like in a report and would then publish this mirrored sheet accordingly. What is the best way to achieve this? I've tried the automation function which work but doesn't prevent attachments and not sure how it would work with hiding / deleting columns?
Thanks!
neilw1976
Re: Has anyone connected Smartsheet forms to an AI service that fills PDFs?
Hi @rcole
Have you looked at the Document Builder feature that is built into Smartsheet already? Maybe take a look at that and see if works for you.
I hope that helps.
Matt
Matt Johnson
Apply notification settings to a specific group only, rather than Enterprise wide
To provide RBAC permissions for notifications and requests to specific groups in the enterprise. This will allow Groups that need to request people outside the organization (i.e, HR- On-Boarding) this allows the section to automate their process. Not every section needs to automate requests outside the organization
jhampton19
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