Best Of
Re: COUNTIFS Struggle – Need a Hand!
Hi @fiorellag
Please try the following formula:
=SUM(COUNT(COLLECT({TBD RMT Range 1}, {TBD RMT Range 1}, [Column2]1)), COUNT(COLLECT({TBD RMT Range 1}, {TBD RMT Range 1}, [Column4]1)), COUNT(COLLECT({TBD RMT Range 1}, {TBD RMT Range 1}, [Column5]1)))
The key difference is that we need to sum all the matching values being found.
Hope this helps.
zealvert
Re: Recommended changes for Resource Manager
Completely agree with the Allocation Heatmap idea. You have my vote!
mdetmering
Admin Access to Everything?
Is there a way that a Smartsheet Administrator would be able to gain access to all sheets/workspaces, even if not specifically shared to the admin? I am asking in terms of access controls, so we can put a control in place where the admin ensures no PI or Confidential informaiton is being added. Thanks!
Teresa Sabino
Re: Calendar App Copy or Save as New option
Great idea! I need to create various types of views from the same calendar. Any update on this request?
Fernando B.
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