-
CHAR(10) not adding internal break
Hi, There's probably a simple answer but when I use CHAR(10) in a cell formula in a form, it results in a space (probably a non printable character) instead of a break. The formula I am using is: =JOIN(COLLECT(Column1:Column1, Column2:Column2, "Responsible"), CHAR(10)) Even if I use: ="Apples" + CHAR(10) + "Oranges" I just…
-
If and formula help
Trying to create the below formula but its coming up with unparseable… =IF(AND(Performance@row <2, Trust@row <2), "C1", =IF(AND(Performance@row <2, Trust@row = >2 <3), "C2", =IF(AND(Performance@row <2, Trust@row = >3 <4), "C3", =IF(AND(Performance@row <2, Trust@row = >4 <5), "B10", =IF(AND(Performance@row <2, Trust@row =…
-
JOIN, COLLECT, Multi Select and Cross Sheet References
I have a sheet with a list of customers and items they have based on item type (multi select columns). I have another sheet that is an inventory of all possible items, item types, and item values (H-M-L). What I want to summarize by customer (row) is what are all the items they have that are considered "high" value based…
-
Index(collect help!
I am trying to get a percentage to pull in based upon 2 criteria, however, the range of percentages is across many columns. The criteria is a bad debt allocation name, as well as the "aging bucket" (or age of account). I have formulas set and working appropriately to give the allocation name, and aging bucket number, in my…
-
How can I create formula to only calculate a set if another column is NOT N/A?
A form was created to collect a scoring of 1-3 for 10 different items. The goal is to collect the values (SUM) and divide by the highest total score (of 30) to get an overall adherence score percentage. This was originally achieved and work by using a helper column to SUM all 10 values into the Score Total column using the…
-
Formula to Trim Cell From Right by Special Character
Hi, I found this elsewhere on the forum and it works 100% as expected but as soon as I change out the special character to what I need it to be, I get Unparsable errors. The formula that works is: =RIGHT([Area Path]@row, FIND(">", [Area Path]@row, 1) - 1) with the desired outcome: But as soon as I change it to the…
-
Index/Match Results Return only matching first entry on list
I"m using Index match to return a contact based on the department entered in another cell. The department entries are copied from the drop down list in the other sheet so they should be exact matches. For some reason it's only returning a value for the first entry on the list, but the others give a "no match" error. This…
-
Move row to another sheet automation dropping contact
I am using automation to move completed tasks to another sheet; however, the assigned contact is not transferring to the new sheet. I have confirmed the format is the same in both sheets. Both are set up as contact columns. Has anyone experienced this and found a solution?
-
COUNTIFS Using And as well as Or
Hello everyone, I am looking to have an information sheet that is looking for several criteria with "and" and "or". For example, I want the formula to count if the other sheet has "Priority 1" and "John Doe" and a status of either 1 or 2 or 3. I will have another cell on the information sheet for "Priority 2" and "John…
-
Challenges with Summary Data Formulas/Dashboard Sometimes working
I have a first sheet that was filled out by people using a smartsheet form to populate a sheet for a certification program. A second program is only open to the people who were already certified in the first program, so they fill out a Smartsheet form with minimal fields, include a unique ID number, and the rest of their…
