Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Prasanth Reddy MPrasanth Reddy M 

object field in activities

when i am trying below custom formula field for creating object in activities, it is continuously showing syntax error...can anyone one help with correct formula here...

IF(
BEGINS(WhatId, “006″), “Opportunity”,
IF(
BEGINS(WhatId, “001″), “Account”,
IF(
BEGINS(WhoId, “00Q”), “Lead”,
IF(
BEGINS(WhoId, “003″), “Contact”,””))))
Best Answer chosen by Prasanth Reddy M
Sai Ram ASai Ram A
Hello Prashanth

Issue is with your "" 

IF(BEGINS(WhatId, "006"),"Opportunity",
IF(BEGINS(WhatId, "001"),"Account",
IF(BEGINS(WhoId, "00Q"),"Lead",
IF(BEGINS(WhoId, "003″"),"Contact", ""))))

If this post is helpful please throw Kudos.
If this post solves your problem kindly mark it as solution.

All Answers

Sai Ram ASai Ram A
Hello Prashanth

Issue is with your "" 

IF(BEGINS(WhatId, "006"),"Opportunity",
IF(BEGINS(WhatId, "001"),"Account",
IF(BEGINS(WhoId, "00Q"),"Lead",
IF(BEGINS(WhoId, "003″"),"Contact", ""))))

If this post is helpful please throw Kudos.
If this post solves your problem kindly mark it as solution.

This was selected as the best answer
Prasanth Reddy MPrasanth Reddy M
Yep,

I figured out the my mistake through some other post.

Thanks for your help.

Prasanth.