I have following formula:

IF(
  LEN( GPS_Customer__c ) > 0,
  HYPERLINK("/" & GPS_Customer__r.Id , GPS_Customer__r.Name__c ,'_self'),
  ""
)

 

Explanation:

If customer (lookup) is given to object "Time entry", let's generate "Customer name" hyperlink which points out to customer object (custom object).

(Customer ID is autonumerated field (CUS-{0}) and therefore i have created this another formula field to hide cryptic ID from application users)

 

Everything works well at salesforce:

Testcompany Ltd link points out to proper record at Salesforce.

 

But when i export report into Excel:

Customer name field is not working anymore.

Expected result should be: Testcompany Ltd without link

 

Suggestions how to tackle this without creating another custom formula field called "Customer link"?

 

Thanks in advance.

 

I have just created a new custom object called Book.
How can I grant full read/write/delete permissions for some part of my organisation?

Problem example:
1. Administrator user will create five book records into custom object
2. John Doe know that book number three is not in use anymore but he cannot delete it because administrator user owns the record.

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_concepts_security.htm
Full Access = "All Users and Groups can view, edit, transfer, delete, and share the record. (Only available for campaigns as an organization-wide default setting.)"

I have just created a new custom object called Book.
How can I grant full read/write/delete permissions for some part of my organisation?

Problem example:
1. Administrator user will create five book records into custom object
2. John Doe know that book number three is not in use anymore but he cannot delete it because administrator user owns the record.

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_concepts_security.htm
Full Access = "All Users and Groups can view, edit, transfer, delete, and share the record. (Only available for campaigns as an organization-wide default setting.)"