I wanted to run a report to fetch all users in our salesforce org and then group them by their License type. Problem with Standard Report: You can use the Standard report on the User object and use the "UserType" field. But the problem is that this field is not very specific. For instance, this field has a type name "Salesforce" for both...
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...
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...