Back to zzTakeoff Community Channel LogoFeature Requests

Formula Error

if([Separate Neutrals] = "Yes", 4, 3) I have this formula with a custom property I created, its serving 2 purposes, first is to create and add to my condition name a Yes or No, second is to determine wire count based on the answer, I got this to work but had to use value and name, with that, I was able to use if([Separate Neutrals] == 1 , 4, 3) and get my wire count to work, however, when I pull [Separate Neutrals] for the name, I get the value of 1 or 2, how do I pull the name part to say Yes or No?


0
Shawn M 2h 30m

I set it up as name only

Then used this formula.

"[prop]"=="yes"? 1:3

Shawn M 2h 26m

or it you want it to say yes no, "[prop]"=="yes"? "Yes":"No"

Shawn M 2h 11m

One more, If you need both parts of the formula to show up, you could do this"

That wont let me use it to calculate another formula:


The yes/no only name option will not work in a formula:


So there are 2 thing happening with this one custom property, I am using it for a name for my item and I am using it for a formula to calculate and change my wire count based on the response.

Shawn M 1h 11m

???


Will that work as a formula for a custom property? I have the formula to change in another custom property, Where is that additional info tab? Or is that a custom property?

And how do you do these GIF images, I tried and cannot get it to work

Shawn M 38m 52s

Snipping tool

Select Record then +New

You choose and area then click start at the top of that screen. After you are done, press stop and it brings up another window

Click the 3 dots and select "Create GIF"

Export it and give it a name, then use the picture icon below and pick the file.

Shawn M 37m 33s

additional info is a custom property

Shawn M 36m 42s

I created it as an alternate to Description because Description is used by the program itself.

Hi Guys, If we could use the Q and A section for formula questions that would help us out and our users.

The email notifications are being sent out to everyone that wants to know about feature requests.

I have gotten over ten on this one...

Jeffrey, if you email me at todd@zztakeoff.com I can try and help you in a zoom mtg

Shawn M 34m 18s

sorry... can you move this?

done, thanks! again Jeff if you need assistance email me and I will try to help you

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