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
Lukasz PiziakLukasz Piziak 

Update Formula with condition needed .

I have field called 'Length MT' (number type). I would like to update this field by a value from my another field 'MAIN ASSY HOSE LENGTH' (number type), but if another field 'Hose Accessories' name contain 'None', formula should use '0.00' value.

Is it possible to create above working formula for updating my custom field?
Thank you for any help
New_DeveloperNew_Developer
try this

if(AND(Length(MAIN ASSY HOSE LENGTH)>0 ,Hose Accessories = 'NONE') ,  0.00 , Length(MAIN ASSY HOSE LENGTH))

if Hose Accessories is picklist field then use ISPICKVAL(Hose Accessories) , 'None'  Instead of Hose Accessories = 'NONE'
Lukasz PiziakLukasz Piziak
Hi,
Thanks for reply,
Please see below errors I'm getting
User-added image
Lukasz PiziakLukasz Piziak
Maybe this info will be important: field 'Hose_Accessories1__r.Name' is a text type field
New_DeveloperNew_Developer
remove the closed bracket ')' after the Hose_Accessories__r.MAIN_Asst_HOSE_LENGTH_VOCAD_CODE__c and what is LENGTH_MT__c. I think it should just be length
Lukasz PiziakLukasz Piziak
Hi, 
LENGTH_MT__c - this is a field where I woudl like to copy my value with condition. It should be fields label instead? 

Thanks