-
How to remove the apostrophe in front of a number on data imported from Excel
I have a column with Rank values on a sheet with data imported from Excel. The rank value includes an apostrophe in front of the number. What is the specific formula I need to use based on the example below? I've been trying to play with the examples given and keep getting errors. Thanks.
-
Formula Help
If I want to compare column 2 of Sheet D to column 2 in Sheet F, and return the value from column 1 in Sheet F to column 1 in Sheet D if 2D and 2F are equal, and not return anything if they are not equal, how would I put that in a formula? I think it's a vlookup but my formula didn't work.
-
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?