Select LicenseDefinitionKey,Name from UserLicense

Now, do a "Excel Vlookup" between the Profile.UserLiceseId column in the first csv file and the "LicenseDefinitionKey" in the second csv file. The Name column in the second csv file denotes the actual salesforce license Name.

If you are not familiar with Vlookup, then watch this video

 

Note:I tried this only with the LEN function and i hope it works with other formula functions as well.

My requirement:

I wanted to calculate the length of a couple of fields of data type Text Area, and put the number into a new field.

As usual, i created a formula field and used the LEN function. When i tried to INSERT my Long Text Area fields, they were not available for selection. I later found out that you cannot use Long Text Area fields in formulas as of now. Hope that it becomes available soon, until then here is a workaround.

Let's say that i have an object named "MyCustomObject__c". I want to calculate the sum of the length of the Long Text Area fields Field1__c, Field2__c, Field3__c and put the value into SumofLenght__c

STEP 1: Create a new field on the object MyCustomObject__c named "SumofLength__c" of datatype "Number".

STEP 2: Create a new Workflow rule on the object "MyCustomObject__c"

Evaluation Criteria: Every time a record is created or edited
Rule Criteria: MyCustomOject Name: NOT equal to NULL


STEP 3:

Create a Workflow Field Update as below

So, i did a data export from salesforce.com and wanted to get the month from a date time field...


The general format of DateTime fields is like this 2012-01-15T18:34:00.000Z


If suppose you have this in column D in excel, just type in the following formula in an adjacent column

Say you do it in E1

=SUBSTITUTE(SUBSTITUTE(D1,”T”,” “),”.000Z”,”")

This eliminates the time part and you just get the date value....

Now, simply double-click on the bottom edge of E1 and the formula would be applied to the entire column E.


Now, E might still represent some number... Select the entire E column, right click and select "Format Cells" and select the category as "Date"...


To fetch the Day, Month and Year from column E, use the formulas = DAY(E1), =MONTH(E1), =YEAR(E1) ...