-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
Sharing folders
Since Workspaces is not conducive to individual permissions, we are trying to use the standard folders under "Sheets". One department has close to 100 files in Smartsheet. We want to use Smartsheet in other departments as well, but would like to organize the departments by folders. With each Sheet, Report, and Dashboard…
-
Allow multiple contacts in Dynamic View "Restrict view by current user"
Summary: Allow the admin to select multiple contact lists in Dynamic View when restricting what the current user can see. I currently have a portal for our various locations to report temporary issues. A good example of this are the recent hurricanes in Florida. Currently, the Dynamic View only allows the submitting…
-
Merged: Strikethrough, for selective text
This discussion has been merged.
-
Column Filtering for Sheets
Enhancement Request: Filters on sheets are a wonderful addition to Smartsheet. Since they were introduced, we have learned to rely on them more and more. One enhancement we would like to see is the ability to filter columns in addition to rows. Please add my vote for this feature. Thanks!
-
Merged: Make the name in Latest Comment row optional
This discussion has been merged.
-
Banded Rows for Reports
It would be nice if reports created banded rows automatically instead of having to create complex formulas in the source sheet to band rows that flow through to reports. Most of our reports come from one master sheet. If I create banded rows based on one set of criteria, it works great for that specific report. However,…
-
Card View - Conditional Formatting
Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry over to Card View...any ideas? See attachments Any help much appreciated, Jack
-
Latest Comment in Cell
Is it possible to reference the latest comment on a row, in a cell? And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opposed to opening up the comments or manually updating the cell to reflect the latest update.…
-
Merged: Export a report as shown with formatting in Smartseet
This discussion has been merged.
