-
Way to use grouping in reports with a multiselect column
Is there a way to group a report using a multiselect column? I have spent a while going thru the community posts going back to when the grouping in reports was released and see that this is something that has been asked about repeatedly with no solution or real work around. We have some sheets that require this…
-
Dynamic Reporting Linking Filters
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive into the report and populate the results. We would like to see it linked so if you change the data on the intake sheet, the…
-
Developing Library check-out list
Hi! I am looking for suggestions/help on a formula for a library check out sheet. In columns I haveL check out date / Number of Copies / Copies Available. I am struggling to figure out an automated process to get the copies available to update once when the number of copies is changed. When the form is submitted it says…
-
Count Multi-Select with conditions
I have a ongoing sheet with Clients (Single Select Dropdown) and Tests (Multi-Select Dropdown). I'd like to know the ongoing total of Tests selected per Client. I can't seem to figure out if this is a combination of Countifs and CountM or if I should use Collect, Has, Contains. I know this is simple I just can't put it…
-
Function to allow the import/export of multiple filters
If we'd be able to export/import filters to be able to share between users this would be an awesome feature that would greatly benefit our office. We have many people looking at the same Sheet but currently if we want to set up filters each user has to create them from scratch. I would think this could be an easy feature…
-
Using Power Automate to bring in email+attachments from Outlook
Hello! I'm a new user/licensee of Smartsheet! Is it possible to attach files/docs to a row via Power Automate? I've set up a simple flow to create rows on a sheet each time an email arrives in a shared inbox in Outlook with the aim of streamlining the collaboration required to respond to the emails. However, all my…
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Enable links regeneration
Currently links to published spreadsheets or reports are "hard coded", i.e. can't be changed. So if someone either from our or from customer's side is leaving the company, they still have an access to potentially confidential information. This "feature" makes use of Smartsheet in the enterprise area very questionable and…
-
Find first non-blank cell with INDEX/MATCH
Hi guys! I'm pulling 2 columns, each with multiples of the same value, and some rows have blanks in the cells until the reference sheet is updated with said information. My INDEX/MATCH works great, except there it pulls the blank values, and thereby reducing the accuracy of my sheet. The formula is as follows;…
