-
Combine Multiple Form Fields into one column
We are using a form to enter new customer information into a smartsheet file. Our key is a formula setup with multiple columns combined to create the unique key, since some of our customers work for the same company out of the same office location and we need to be able to search by all. Is there anyway to combine in the…
-
Improving Formula Descriptions
I feel like it could be better shown, for a variety of examples, how formulas can be used. For example, this image doesn't really tell you what the answer to the example is. The example only shows that those data types can be used but doesn't help you understand what it does. Minor gripe I suppose. Also sometimes I wonder…
-
How to catch duplicate data using formulas or premium apps?
Hi, Good day! I need help in catching this duplicate data with the same Service Type and Last Name but the First Name is different because the first one has middle initial. Can this be caught by sort of using formula or premium apps like datamesh? Anyone have a great mind or idea how to make a new column and formulas then…
-
Timestamp - Record Date & Time in a Field
Hi there, I want to set up a workflow with multiple approval steps and record e.g. when each step was approved; is there a way to push the 'current' date and time - as a fixed value, not as =TODAY() - into a cell ? The modified date/time only catches the last modification of the whole line, so that's not going to work for…
-
Who could use a PARSE function?
So I have been trying to think of how to best word it, and trying to help someone else with a solution led me down the rabbit hole I needed. How about a PARSE function. =PARSE(range, selection number, delimiter) Use case would be plentiful, but a couple of examples would be... A. You want to search a range for the second…
-
Look Up Table Matching
Hi everyone, --------------------------------------------------------------------------------------------------- Apologies all, it seems I have managed to figure out the below and have previously had help with a similar query - see link for solution.…
-
Using Countifs with Ors and Ands
I am looking for help with a formula. Hopefully there is one out there. I have several columns Month, 1 Assigned to, 2 Assigned to, 3 Assigned to, 4 Assigned to, and Status. I need to count if it is in say month 1 and assigned to office in any of the Assigned to columns and the status is open. Is there a way to have the…
-
Match any part of multi select to another multi select on another sheet
Hello, I have two separate sheets that each have multi select columns and I want to join a particular column if it has ANY mutual matches between the two. For example, on sheet 1, A B C are selected in the multi select and I want to find any matches on sheet 2 which contain anything selected from sheet 1. The column on…
-
How can I copy information to a new sheet to create a log?
I'm trying to see if there's a way to have data copied from a few specific columns to a new sheet. I'm hoping to create a log for IT issues as they occur on requests. The difficulty is setting some sort of trigger that will move the information over into a new row whenever a new issue is added. The other possibility, would…
-
Formula for Star Rating that Ignores Blank Cells and O Values
I would like to Average the Star Ratings provided by seven people in the Rate Column. The formula I have in the Rate Column is NOT ignoring blank cells or cells with a 0 value. The image below shows the hidden columns that are connected to the formula. =AVG([DH#]@row, [JH#]@row, [RH#]@row, [JM#]@row, [RF#]@row, [KM#]@row,…