-
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?
-
The Smartsheet Customer Support Portal is HERE!
Hi Community, We are excited to announce the new Customer Support Portal. Now, you will have one location to open support cases, provide additional information to your support case, and track your support cases until closed. The portal also includes a search function so that you can search for knowledge articles related 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…
-
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…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
