Best Of
Re: Adding Column Descriptions to Reports
This would be a game-changer!!! Please prioritize this enhancement.
Amanda Fulbright
Re: Adding Column Descriptions to Reports
Particularly useful when a report has more than one user group / audience
Ide AirTrunk
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.