Command CHOOSE inside Spreadsheet

[Elton Freitas]

It's possible to put command "CHOOSE" inside Spreadsheet?Can you help with example?
Thanks

[Tim Wessman]

Are you looking for a dropdown type object? If so, then no.

If you attempt to use CHOOSE it will run when the evaluation of that cell happens. That may or may not be what you are wanting.

[Elton Freitas]

(08-25-2015 02:00 PM)Tim Wessman Wrote:  Are you looking for a dropdown type object? If so, then no.

If you attempt to use CHOOSE it will run when the evaluation of that cell happens. That may or may not be what you are wanting.

Yes, I'm looking for a type object dropdown! Any way around this?

[cyrille de brébisson]

Hello,

My understanding is that you want, in a cell, to have a choice of 1 out of N possibilities.

This means that each cell would need to contain 2 items. The list of choices and the currently selected one.

Unfortunately, there is only 1 item per cell, the formula, it's value being recalculated each time...

so, no, sorry but at this point in time, I can not think about any workaround for what you want to do...

Cyrille

[Elton Freitas]

Thanks!
It is a pity not being able to do it.We are would have many possibilities with this feature.

Elton Freitas

[Tim Wessman]

Hello,

We'll put this on the list of potential improvements. I agree it would be a nice thing to have.

Just for clarity, something simple like (in B1) =CHOOSE(1,"Select",B2:B6) work for you in your mind? You couldn't take a direct action on change (like excel where this type of thing seems to be used primarily to do a sort or similar), but it would cascade the choice through other formulas.

Thus =B1*5 would multiply the selected item by 5 in the formula.

[Elton Freitas]

Hello

Really this is very interesting and for us to do a lot of applications.Something as simple excel that seems complicated in Prime.

Elton Freitas