-
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.
-
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")
-
How to create a countif formula with OR
I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine. =COUNTIFS({Comments Log Range 1}, [Document Name]@row, {Comments Log Range 2}, "Preliminary Draft", {Comments Log Range 4}, "Open") However, the value in range 2 can also be…