Best Of
Re: Rich Text formatting in cells
In case anyone is collecting requirements from this thread, below is my wishlist for Rich Text edits within cells in sheets:
- Hyperlinking multiple strings
- Eg. This thread is a part of Smartsheet Discussions.
- Formatting:
- Bold,
- Italic,
- Underline,
- Strikethrough
- Text color
- Bullets
Thanks for listening.
Chris Topher
Re: COUNTIFS Struggle – Need a Hand!
Your formula is close. Your syntax for the OR is just a bit off is all.
=COUNTIFS({Range}, OR(HAS(@cell, [Column2]1), HAS(@cell, [Column4]1), HAS(@cell, [Column5]1)))
You can also simplify a bit by specifying that we count everything that is not [Column3]1
=COUNTIFS({Range}, NOT(HAS(@cell, [Column3]1)))
It can be even more simplified if you are not referencing a multi-select dropdown by looking for equal or not equal to.
Paul Newcome
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