Best Of
Re: Adding Column Descriptions to Reports
Column descriptions from sheets should also be visible on all reports using that column. It is important information for anyone using a report, just as it is for those viewing a sheet. Thank you
Jenna714
Re: Rich Text formatting in cells
Would like to be able to format only specific text within a cell. For instance make certain words bold, add bullet points to only specific parts of the cell etc.
lisacd
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