Combining Market Min and Market Max in a new field to create the "Market Range"

[tdiehl12]

We added custom fields on our Annual Compensation template; "Market Min" and "Market max" are pulling into 2 separate columns on our template and are pulling directly from EC onto the template. I'd like to also add a "Market Range" column which would display the custom fields Market Min and Market max as follows:

"Market Min - Market Max"

What formula can I use to display the two fields with the "-" in the middle? 

[xavierlegarrec]

Hi @tdiehl12 

You need to turn the source columns into type=String otherwise it cannot be done. 

Once you have the Min and the Max custom columns as String then create a 3rd column and add the following formula:

customMin+"-"+customMax

All the best

Xavier

[tdiehl12]

Thank you Xavier! This worked! Any way we can then add the commas for the numbers now showing within the market range?

[tdiehl12]

Thank you @xavierlegarrec - any way we can format the new market range field to display commas within the formatting of that market range now?