function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Matt Goulding 1Matt Goulding 1 

"Using Formula Fields" Trailhead challenge error

Hi, Looking for some help please. I'm trying to complete the challenge on the "Using Formula Fields" module, but I cannot get the syntax right on the formula fields. I cannot select or paste in the Account.LastModifiedDate.

Any suggestions, welcomed as I would really like to finish and work out what is wrong with the formula!!

User-added image
Best Answer chosen by Matt Goulding 1
Amit Chaudhary 8Amit Chaudhary 8
It look like you are creating Numer type field not formula Field.

All Answers

Amit Chaudhary 8Amit Chaudhary 8
Please create one formula field with Number type on case object like below 
(Today()- Account.LastActivityDate)
Please check below two post for screen shot
https://developer.salesforce.com/forums/?id=906F0000000BSUKIA4
https://developer.salesforce.com/forums/ForumsMain?id=906F0000000BQwUIAW

Please let us know if this will help you
Matt Goulding 1Matt Goulding 1
Hi - Apologies the first screenshot attached is not great, but it does contain Today() - Account.LastActivityDate. I get an error message that Field Account does not exist. So the expected answer does not appear to be working and I cannot see what I am missing.
Added a better screenshot.
User-added image
Amit Chaudhary 8Amit Chaudhary 8
NOTE you need to create formula field on Case object.
Please check below post with screen shot.
https://developer.salesforce.com/forums/ForumsMain?id=906F0000000BQwUIAW

 
Matt Goulding 1Matt Goulding 1
Yes. I am in the cases object as per top left of this screenshot. Still not able to work out how to move forwards. Based on all the previous posts on this topic, the formual appears correct.
User-added image
Amit Chaudhary 8Amit Chaudhary 8
It look like you are creating Numer type field not formula Field.
This was selected as the best answer
Amit Chaudhary 8Amit Chaudhary 8
If it is possible then please share your user name and password with me on my email id (amit.salesforce21@gmail.com) , so that i can look into issue
Matt Goulding 1Matt Goulding 1
Thanks Amit. I was creating a number field instead of a formula field with a return type of number. Appreciate the help.
Zachary GoldbergZachary Goldberg
Wow, just wanted to say what a help. Not sure if I missed something in the trailhead training but that solution was not obvious. Thanks for the help Amit!
Evelien MeuldersEvelien Meulders
Thanks for the help on the syntax. :-)