Back to zzTakeoff Community Channel LogoQ & A
35d 16h

Value from dropdown

Is it possible to use the value from a dropdown (Value & Name) in a formula?

0
John L 33d 18h

You mean without selecting the correct option in the drop down? Wouldn't it just be easier to select the correct drop down option then reference that custom property by name rather than by value? I feel like that's the entire point of Value and Name drop down

KevOB 33d 15h

No I have task descriptions in a drop down and I want to have a value for each, to use the description would require a long set of if formulas

I believe this is the current behavior. Right now, if you add a dropdown that is value & name, and choose (for my example below), "Number One" when you reference that property/dropdown in a formula, it will pull the value "1". Separately, we are considering adding a way to reference the "Name" from the dropdown.

John L 33d 14h

This is 1 of the ways I'm using Value & Name....





The property is titled "Difficulty Factor" which is really just a labor modifier. It makes my area take offs have this


which in turn means my formula only needs to include something like this in order to use any of those options.


KevOB 32d 8h

John - this is exactly what I want it for

KevOB 32d 8h

The problem is I can only pull the name not the number

KevOB 32d 8h

Lorin - my behaviour seems to be the opposite, I want the number but getting the name

In that case, you need to swap the columns for your dropdown options. The left column is the "value" or what will be used in the formula, and the right column is the "name" or what will be displayed when you choose the dropdown.

KevOB 31d 20h

I had a play around and after deleting and remaking it it worked but the issue I have now is the name will no longer show only the value, is there a different way to get the name? i.e [Difficulty factor] gives the value "1" ([Difficulty Factor][Name]) gives the value "Easy", or could it be implemented to work if you added quotation marks?

Hey Kevin, currently, it's only possible to reference the value in "Name & Value". As I mentioned previously, we are planning to add the ability to reference the "Name".

You must be logged in to post replies. If you don't have an account you can signup here.