-
Sorting by Dropdown Order (in Reports)
please tell me that I can also "Sort by Dropdown Order" (in a report)? I know you can do it in your sheet when you are in "Table View" however, I have a report that I need to sort by this column (drop down) and because of alphabetical rules: Draft Protocol not Rec'd (13M) comes before Draft Protocol not Rec'd (9M) HELP!
-
Reports Based on "Assigned to" Across Sheets
I am creating templates that our marketing team can use for different categories of projects that the director will use to create a "task sheet" for new projects. Columns that the templates have in common (including Assigned to) will be named the same. A project owner managing the task sheets will add contacts to "Assigned…
-
Counting number of items from a specific month with multiple criteria
I'm trying to count the number of items that were published for each LOB in our operation during each month. I've tried a dozen different formulas, but I can't seem to get any to work. I currently have a sheet summary with the following: =COUNTIFS([Received Month]:[Received Month], IFERROR(MONTH(@cell ), 0) = 1, (LOB,…
-
Column widths should be lockable
I'd really like to have the ability to lock a column width and/or have the column remember each person's/device's last width setting. See: https://community.smartsheet.com/discussion/87852/lock-column-width I work with several sheets multiple times a day that I share with a co-editor. Because of differing screen sizes and…
-
Filter On by Default? - Publish to Dashboard
Is there a way you can "lock" a specific filter on by default for a sheet you publish to a dashboard? I'd like to have the sheet editable from the dashboard, but I'd like it filtered to "current user" so it can act like a one-stop shop for everyone to review the reports and update the sheet at once. I have one filter on…
-
Bring Back - Middle mouse button opens new tab in background
As the title suggest, re-adding this feature is essential for efficiency nerds and clicks-per-minute-analysts like me. I start everyday looking at and analyzing about 8-9 different sheets. Going to the "recent" menu is my best friend. I just hover on top of each desired sheet and press middle mouse button which opens a new…
-
Document Builder: Conditional Formatting & Symbols
It would be great if document builder was able to: either apply conditional formatting within the builder or carry through conditional formatting from the source fields/sheets able to pull through field properties such as symbols as the graphical representation rather than the backend text e.g. I want to include project…
-
Hidden Form Fields No Longer Writing to Sheet
I have a form that has two hidden fields at the top to indicate which location is using the form. These are necessary to the PowerBI report that uses the data. All of a sudden these fields no longer save when the user submits the form. When I unhide them, they show after submission. I would really like to have them hidden…
-
Using Bridge to populate Contact Columns
Hello, I am using Bridge to map specific columns to another sheet. I am finding using the Contact column is extrememly problematic. I have a column that lists internal staff so the names are loaded in Smartsheet contacts already. However, when using Bridge, it works most of the time until it doesn't. Also, I have columns…
-
Total Sum not calculating in Smartsheet correctly
Hello SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?