-
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!
-
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…
-
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…
-
Board View - Right Panel - Text No longer "Wraps"
It seems the header/title in Board view when the right side panel opens, no longer wraps. this makes this section very long if you have a mid to longer length header to the point you may not be able to even get to the Attahcments and Conversations section. Can you please update this so that the header/title wraps and the…
-
Sheet Summary changes overwritten by other users - can this be prevented?
I have a sheet that has sheet summary values I occasionally need to update the formulas for as factors change however I've found that when other users are updating the sheet (it's a testing sheet) the changes I make to sheet summary formulas are overwritten as those users update their test statuses. Aside from making the…
-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
-
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…
-
How can stakeholders search within a Dynamic View?
Hello! This is my first post in the Smartsheet Community - thanks in advance for any help. Problem: I’ve created two Dynamic Views that consolidate data from multiple systems into Smartsheet. Each row represents a unique SKU, and stakeholders need to search by SKU to view multiple status columns coming from different…
-
Created Time
So I am trying to extract the timestamp from the created date column and its making me feel crazy. The TIME() function help file describes a formula that should work exactly how I want - however NOTHING as described works at all. (https://help.smartsheet.com/function/time) =TIME([Date Created]@row) returns "INVALID DATA…