Best Of
Re: Linking forms in a dashboard.
I submitted a similar request some time ago and was searching here to see if there was an update. I did not find my idea so am up voting @John_Foster's!
Our use case:
We have template workspaces each containing sheets, reports, and dashboard. We copy a workspace for each project. Some sheets have forms. Every time we copy a workspace we need to go to open the sheet, go to the form menu, copy its URL, and add that URL to the dashboard. Not having to do this would be a significant improvement in efficiency and accuracy.
KPH
Re: Datatable Lookup Mode: Checkbox if no Unique Identifier Value was found in the Datatable
Hey @NeilKY
Thank you for posting your solution. I'm glad you got this resolved!
Marcela
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