-
Comparing Cell Contets
Comparing Employee names from FORM (no sign in required) in sheet with the Employee contact list Formula ? I have a master sheet that gathers: training Name and attendees names. i will like to generate the list of who did not attended the training. What is the best function to use for this? Many thanks,
-
Inventory - How to let multiple users claim an item without seeing others' selections?
Hi All, I'm in the process of building an inventory type system in Smartsheet for my company. I have one sheet that tracks inventory for each location. I'd like to have it so I can show employees inventory for their respective location and then if they want an item, click a checkbox and I record their responses. I do want…
-
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…
-
Create copy of Smartsheet data, scheduled and automated to be used as trendlines
I have created a PowerBI dashboard using smartsheets as the data source. Live updates are working perfectly, and updating data is running smoothly. I have been asked to show a trend line, and progress with these metrics. How can I build a table (or Smartsheet) using snapshot data in an automated workflow using smartsheet?
-
Document generation error on creation page
I have a template I've used for a few years that all of a sudden will generate and download, but not generate and attach to the row (as I need it to). Is there a setting I need to change? It just sits there and shows it's attempting it (I've waited 12 minutes for the last one), but the download one will complete itself in…
-
Recording the Date when a Status changes in a column
Hi, I am looking to build reports on how long it took for a status to change into another status. I have read some of the previous solutions; record a date automation, but it seems like this isn't working for me. When I am trying to create the automation it gives me only one option in the "record a date in" > "select a…
-
Add Hyphen Checkbox schema to help with tracing a sheet to its location within a Workspace/Folder
When a user clicks on the "Sheet" button in a report to find where the source sheet(s) is found it is extremely hard to locate which workspace/folder the sheet is located within. It would be extremely helpful to use the UI design Smartsheet already uses when less then all items within a folder are selected; a hyphen in the…
-
Merged: Tracking Users' Sheet Views, Edits, Shares... All Activity
This discussion has been merged.
-
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…
-
Dynamic View accessibility
My colleague have created a dynamic vie of the Smartsheet and shared it with me and others. To access the Dynamic view, is it necessary to have a license of the Smartsheet? Or only having the access to that sheet will suffice? I'm getting attached error. Need assistance on this.