How to add a formula within brackets

[arceaf]

Hi,

I need some help adding a formula in a cell that is within brackets.

On a cell, I type in "{" but then try to reference another cell (ie: c4). For some reason, I am not allowed to add neither an formula nor any sort of reference to another cell. Anyone know how I can get around this? I need to have the "{" in the cell.

Thanks!

 

[Noodleski]

What does this formula need to do?

 

[arceaf]

Something like this:

{ "Color" : =c4}

The cell c4 will have the name of the color. Does that make sense?

Thanks!

 

[pgc01]

Hi

Try:

="{""Color"" : "&C4&"}"

 

[Noodleski]

Something like this:

{ "Color" : =c4}

The cell c4 will have the name of the color. Does that make sense?

Thanks!

I'm afraid I'm not familiar with that syntax. Nor is it clear what you want to do.

If you want to enter 'Blue' in cell C4 and you want A1 to show { "Color" : Blue}
you could try in cell A1:
"{ 'Color' : "&A1

Notice I took a shortcut by exchange the " for ' in the formula as the " would complicate things. Sorry if I misunderstood your question. Perhaps post an example of what you want to achieve.