-
Extract the 2nd name from 3 names when delimeted by ,
Hi Smartsheet Gurus How do I extract the 2nd name from a column that has 3 names that has a delimiter of , (comma) Mickey Mouse, Donald Duck, Minnie Mouse - I want to extract Donald Duck thanks much, Bruce
-
Countif Star Ratings
Does anyone know the formula to count the 6 star ratings (0 to 5 stars)?
-
If cell contains text, autofill another cell but don't overwrite existing text
I'm looking to see if something is possible with SS. We have internal teams that request our support for their clients. Depending on the client support level, there are different options available. Our solution was to have 2 different forms for the same sheet so we can track everything in one place. The top 50 clients have…
-
Combine two IF formulas
Can someone kindly help me combine these two formulas? It's too complicated for the AI formula generator. :) =IF(MONTH([Global Trade Compliance Approval Date]@row ) = 1, "January", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 2, "February", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 3, "March",…
-
Current user metric widget
I have an evaluation form that gets filled out and results can be viewed on a dashboard. I have two, one for the submitter to see only their entries and one for the location being evaluated and the viewers see only the evaluations that are pertinent to them. I have a sheet summary formula that counts the total visits and…
-
Linking Columns of 2 Sheets to Feed into a 3rd
Hi There, I believe this should be fairly simple, however the steps are lost on me. In particular I am looking to take a single column from two seperate sheets and have them feed into a third. In this instance I am taking a Request Form (office supplies, multiple options from drop-down to cell) and an Inventory Form (cost…
-
Text to Rows--Possible?
Hello, I've been all over the community forum and looking at various brilliant solutions, but can't seem to figure out how to do what I need. I have a form that has a field (Information) for a list of Number and Date entries. Instructions tell users to use a semicolon as a delimiter. I need to parse them into separate rows…
-
Chaining together IF statements
I would like to know if it is possible to chain together if statements using the & symbol, similar to Excel. e.g. =IF(Brand@row="","",Brand@row&" ")&IF(Model@row="","",Model@row&" ") I have used this method in Excel, but this doesn't work in Smartsheet. Is there a way to make this work?
-
number of cross-sheet references has already been reached
Hi team, I am getting error "number of cross-sheet references has already been reached" while adding formulas to a sheet (let's call it sheet B) that are using cross functional references referencing Sheet C. I am confused as I have another sheet (sheet A) with more references and I did not get the same error. Also if on…
-
Formula Help: Choosing Most Recent Fields Across Sheets
I’m working with two Smartsheet sheets: Sheet A: Tracks courses taught (each row has 2 instructors + 2 courses — both instructors taught both courses). Sheet B: Lists instructors. I want to display the most recent course(s) they taught, pulled from Sheet A. My challenge: Because Sheet A has two instructor ID columns…