-
View user activity / usage in the Smartsheet
How to see what a user has done within SmartSheet across a specific timeframe? is there a way to view user activity / usage on there?
-
Report Grouping: custom sort order of groups
Current limitation: When grouping by a column in the report, I’m forced to choose either Ascending or Descending order. This prevents me from grouping without altering the original sort order based on another column. Request: Please allow grouping by a column without forcing a sort order on it. (Also would be great to…
-
How to parse a value from a concatenated field?
Hello! I have a column in a sheet that is being populated with multiple pieces of information from Data Mesh. As shown in the example below, the cells in this column contain multiple dates. I would like to parse out a single date from this column (Actual Deadline Achieved) into another column. I don't need the text "Actual…
-
Creating a technology device loaning process
Good day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now. My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out to other teams for certain periods of time. I have been working on a loaning process…
-
Case Collaborator in the Customer Support Portal now generally available!
Hi Community, You can now add collaborators to your support cases so that additional stakeholders can also track and manage a support case. How do I submit a case in the Support Portal? 1. Go to http://supportportal.smartsheet.com/. 2. Brandfolder customers can submit a support request via the Contact Brandfolder Support…
-
How to get a formula to count only negatives or only positives
I have two formulas for a helper column to a metrics sheet. I made a column that counts the number of days until an order is due to arrive, and then there are two helper columns. the first needs to take those numbers and return a value based on the number. So if the order is set to arrive in 5 days, then the value would be…
-
Dashboard breaks after removing an Admin (original owner/builder of Dashboard but not current)
We have a Dashboard (several Dashboards that this same behavior happens on) that was built by one person. The Ownership for the Dashboard and ALL associated items (Metrics Sheets, Reports, Source Sheets, etc.) were transferred to another person. The person who built the Dashboard originally (who is no longer the Owner of…
-
Follow-up survey emails from Support
Hi Smartsheet. When a case is closed and a survey is emailed, can it please include a description with the case number? Thanks.
-
How can I create a Dynamic View to show contact field information by hoovering over the contact?
In a regular sheet, when you hover over a contact field it will show the contact's information. (Email, Phone etc). Is there a way to create a Dynamic view to all be able to display the contact field's information by hovering over it?
-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…