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
puneet-mishrapuneet-mishra 

show checkbox value on excel

I have a report including some fields (checkbox) and when it is exported to excel, the value on this fiels is either 1 or 0 depending if the box is checked or not.  The users don't want to se numbers they want to see:  1= Yes or 0=No.  Do you know if there is any way to change the values of the checkbox when exporting?

Arunkumar.RArunkumar.R

It's not possible while exporting data from salesforce...

 

Once you exported you can change 1 or 0 using condition ..

 

http://www.youtube.com/watch?v=8BTrsRFdbY8

 

Please check this above video it may helpful to you...
Sunil NandipatiSunil Nandipati
Create a formula with a return text as Yes or No for your boolean fields.