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
Christine MatthewsChristine Matthews 

Formula for auto-populating a field only if it is blank.

I want to auto-populate a formula text field only if it is currenlty blank. This allows it to not happen only when the record is created and it won't update if it is already populated. 
VinayVinay (Salesforce Developers) 
Hi Christine,

Try below formula. 
IF(NOT(ISBLANK(text__field__c)), '', 'autopopulatevalue__c')

Please mark as Best Answer if above information was helpful.

Thanks,
sarika shirkesarika shirke
The formula to auto-populate a field only if it is currently blank depends on the platform you are using. Here is an example of how you could achieve this in a platform that supports formula fields, such as Microsoft Excel:
In the cell that you want to auto-populate, enter the following formula:
lessCopy code
=IF(ISBLANK(A1), "your value", A1)
In this example, A1 is the cell that you want to auto-populate. Replace "your value" with the value that you want to populate the cell with.
Copy the formula to other cells, as needed.
In this formula, the IF function checks if cell A1 is blank (i.e., if it contains no data). If it is blank, the formula returns "your value"; otherwise, it returns the original value in cell A1. This way, the formula only auto-populates the cell if it is currently blank.
Regenerate response
https://www.dqfansurvey.one/
Shri RajShri Raj
IF(ISBLANK(Your_Field__c), Your_Calculation, Your_Field__c)