-
Need an Formula to generate Categories column
We are looking for the Categories to auto generate from the sub-categories multi dropdown selection. We were achieved this by using the =IF(COUNTIF([Sub-Categories]@row, CONTAINS("Fruits", @cell)) >= 1, "Fruits") + CHAR(10) + IF(COUNTIF([Sub-Categories]@row, CONTAINS("Meats", @cell)) >= 1, "Meats") + CHAR(10) +…
-
Best way to set-up an index contains
Hello Smartsheet, I have a sheet with URLs from our website that I need to be able to flag by division. To do this I have set-up a master sheet with the division's name and base URLs. What I need now is a formula to grab the division names from the master sheet. My intent was to set it up as an INDEX(MATCH()) but I realize…
-
CountIF / IsDate combination
Hello I am trying to link formulas to count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well. Thank you in advance.
-
VLOOKUP to another sheet using images
I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the image. This would be so useful to actually pull in the image itself as a…
-
Copy updated cell values of one sheet to another
Hi, I have two sheets with exact same columns. When any cell(s) value of row in sheet 1 is updated, then I want to update same row with unique identifier ID if existing in sheet 2 to be updated with new cell values as well. Please help how it can be accomplished. Example: Let say Price Per unit of Row 3 is changed in first…
-
Cell-linking - counting values from a sheet into the cell of another sheet
Hi everyone, I'm trying to create an event summary sheet that captures data from individual event sheets to provide a live overview on where we're at with completion, health, risks, status, etc. And so I have a cell "Health" in my specific event sheet that has a number of dots (red, green, gray) depending on with the task…
-
Join IF Contact Type = Customer
I have a sheet with the following columns: Contact Type | Email In the Sheet Summary, I have a field where I would like to create an email string that can easily be used to paste a bunch of email separated by a semi-colon for easy sharing. I want to join all emails where Contact Type is "Customer" into a single field with…
-
Lord Help Me!
Would appreciate some help with a formula! I ultimately need a column that either shows a count based on the difference between two dates, or a "0." In one column, we indicate whether a job post is open. "Yes" it's open, "No" it's closed. In another column, we show the date the job was posted. In another column, we show…
-
Formula to move a cell from one sheet to another based on conditions
Hi all, I'm currently using Zapier to move data from a google drive to a data source Smartsheet. During the transfer, sometimes there are multiple rows with the same claim numbers on the data source sheet (that part isn't going to change unfortunately). I have a separate summary sheet that that pulls the information I need…
-
Issue with Concatenate formula
I'm currently using the below formula, however it's abbreviating the first name rather than spelling out the whole name. I'm having a hard time identifying what I'm missing within the formula: =(LEFT([First Name]@row, 1) + "." + [Last Name]@row + "@gmail.com")
