You need to sign in to do that
Don't have an account?
Sudha Kundathil Mohanan
Formulas practice problem
I am trying to finish the challenge in first chapter of formulas and validation in beginner trail(developer) to calculate the number of days between today and last activity date on a custom object.when I click on check challenge! I always get error message saying formula is incorrect.
here is the formula I did. TODAY()- LastActivityDate.
can anyone help?
here is the formula I did. TODAY()- LastActivityDate.
can anyone help?
so the formula is:
Today() - Account.LastActivityDate
Thx
Appreciate you help.Here is what I did to complete the challenge.
I created 2 custom objects, Account and Case.
I checked the Track activities checkbox to enavle the Last Activity Date Field in Account Object
In the Case object, added a custom field called 'Days Since Last Update' as Formula field returning Number.
I entered the formula,TODAY()- LastActivityDate.(Probably here I'm wrong not mentioning account.LastActivityDate)
There was no Syntax error in the formula.
But when I check the challenge, I get the following message
Challenge not yet complete... here's what's wrong:
The 'Days_Since_Last_Update__c' formula field did not return the correct number of days between an Account’s Last Activity Date and today
I tried your version of formula also.
I get "Error: Field Account does not exist. Check spelling" error.
I'm unable to see Account Object when I try to insert field into the formula bar.
Request your help.
Thanks in advance.
You dnt need to create custom object account and case. You just need to use salesforce standard object Case.
Please follow below Step to complete this challange
Step 1:- Go to Setup--> case -> custom field.
Step 2:- Then click on New Field and select formula field as Number
Step 3:- Then add below formula
NOTE:- API name should be same.
Pleas let us know if this will help u
Thanks
Amit Chaudhary
Today() - Account.LastActivityDate
Thx
ps you should change the number decimal places to 0.
I am also facing the same problem. I used the Formula (Today() - Account.LastActivityDate) but when I click check syntax, an error message "Field AccountName does not exist. Check spelling." is displayed.
Can anyone pls help? I am stuck to complete this challenge.
Thanks in advance
Anshuman
I hope you are creating formula field on Case object
Hi @Ajay, Just need to create formula under Setup > Case > Field. For the formula return type choose number and
the formula is (TODAY() - Account.LastActivityDate). Hope this helps! :)
Creating custom CASE field. SEE the Last Activity Date displayed and working.
Been at 5+ hours. Any new advice?
The 'Days_Remaining__c' formula field did not return the correct number of days between the contract end date and today.'
Hello,
Create a formula field that determines the number of days between the end date of a contract and today.
Your renewals team wants to see how many days are left before a contract expires. Create a formula field that meets these requirements.
Object: Contract
Formula Return Type: Number
Field Label: Days Remaining
Field Name: Days_Remaining
Field Level Security: Visible and Read-Only for all profiles
Add the field to the standard Contract Layout page layout
The formula should return the number of days between the contract end date and today
The resulting API name for the field should be Days_Remaining__c
Challenge not yet complete... here's what's wrong:
This is a challeage:
I created below formulaes with Return type as Number
Formula 1:
EndDate- TODAY()
Formula 2:
IF(( EndDate - today())>0, EndDate - today() , today()-EndDate)
none of these works.. does anybody know what could be the answer to the trail