-
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
-
Reporting: Multi-Select Data, Best Practice?
I have a multi-select column I'm trying to count instances of for each quarter of each year. I created a make-shift report using a sheet and I'm looking for help to determine if there's a better way to do this. Report I created: I've duplicated that sheet into more columns so I could share the formulas I am using. The left…
-
Auto-Populate Addresses using list of all addresses in our City?
We have a list of EVERY address in our city. It contains 455,598 rows of addresses (Woohoo!) That's a LOT of addresses, I know. It could be trimmed down to about half that if needed. We'd like to auto-populate fields in Smartsheet using those addresses as a reference point as the user types the address. How do we…
-
Formula to calculate the difference between two numbers based on a month in another column
I am unsure if it is possible to do what I want, but I wanted to ask. I have attached a copy of my grid. I want a formula to calculate the difference between the largest and smallest numbers for each well for each month. For example, for well #2 in month one, find the largest number (58650300) and subtract the smallest…
-
Return Value based on two criteria
I have a hard time explaining this, but will try my best. I attached a spreadsheet example to illustrate. I want to lookup a value first based on the customer to return the assigned manager. If there is no Customer, then I want to look at the group to return the assigned manager. What is the best way to go about this.…
-
Mixed Sheet Structure
I have a Sheet where users enter tickets for Enhancements to current applications. These could be any type of requests and there are several steps necessary prior to approval to start work. There are two types of enhancements that when approved are 'tracked' on a different log, though specific fields updating the primary…
