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
Vladimir BessonovVladimir Bessonov 

how to use custom field value in formula?

I am getting an error 

IF( DATE(Calibration_Valid__c) >  ADDMONTHS(TODAY(),3) , "NOT CALIBRATED", "CALIBRATED")

Error: Field Calibration_Valid__c may not be used in this type of formula

Calibration_Valid__c is valid API. It is an existing field)
VinayVinay (Salesforce Developers) 
Hi Vladimir,

What is the data type of the formula field?  Maybe check and change the datatype of formula field it might not be compatible.

Thanks,
Vladimir BessonovVladimir Bessonov
It is pickup flield I need to check the dates and based on that set the value of pickup field “not calibrated, close to expire, calibrated”
VinayVinay (Salesforce Developers) 
This will not work for picklist and the above error says the same try to change to the date or can you elaborate more with fields along with data type used in the formula.

Thanks,
Abhishek BansalAbhishek Bansal
Hi Vladimir,

As per your response, you are saying that Calibration_Valid__c is a picklist field and in your formula you are comparing this field with the Date value which is not a valid case.
Please let us know what is your requirement here so that we can guide you.

Thanks,
Abhishek Bansal.
Vladimir BessonovVladimir Bessonov
Calibration_valid__c is data Status is pickup list
Abhishek BansalAbhishek Bansal
Please let us know your complete requirement. Only then we can help you