I apologize in advance if my request looks like a mess :) I'm used to working with excel, and am new to SalesForce.
I have a report with the names of departments, and I need to group by those department names. However, However, the department names are not clear enough for my needs.
I'm looking to do the following: add a column that uses a custom formula, and this is how I would do it in excel:
How would I go about adding something like this to a SalesForce report?
Also, instead of using an exact match, how can I do the following:
IF (FIELD_Name) CONTAINS "biot" THEN "BIO" ESLE IF()....