 0 Points
Posted 3 years ago
Ⲇanom the ultimate (Dan Diebolt), Champion
 30,224 Points
Try this:
If([20 Yard Dumpster], 350,
If([30 Yard Dumpster], 400)
)
I assume both of your fields are Checkboxes so there is no need to test if they are equal to the literal value true. The above formula will test the [20 Yard Dumpster] field first and will not further apply any logic if it is true. Also, if both fields are false the formula will not return a default value.
If([20 Yard Dumpster], 350,
If([30 Yard Dumpster], 400)
)
I assume both of your fields are Checkboxes so there is no need to test if they are equal to the literal value true. The above formula will test the [20 Yard Dumpster] field first and will not further apply any logic if it is true. Also, if both fields are false the formula will not return a default value.
 20 Points
Your parentheses were in the wrong place.
You could also have written this as a Case statement
Case(true,
[20 Yard Dumpster]=true,350,
[30 Yard Dumpster]=true,400
)
Alternatively, if you are making a "choice", you might instead want a different field selection such as [Dumpster Type] with the options "20 Yard" and "30 Yard"; rather than having two separate fields which can both be filled in. In this case your formula would be:
Case([Dumpster Type],
"20 Yard",350,
"30 Yard",400
)
You could also have written this as a Case statement
Case(true,
[20 Yard Dumpster]=true,350,
[30 Yard Dumpster]=true,400
)
Alternatively, if you are making a "choice", you might instead want a different field selection such as [Dumpster Type] with the options "20 Yard" and "30 Yard"; rather than having two separate fields which can both be filled in. In this case your formula would be:
Case([Dumpster Type],
"20 Yard",350,
"30 Yard",400
)
Ⲇanom the ultimate (Dan Diebolt), Champion
 30,224 Points
My formula works with the parentheses as is.
If you use a Case() function you can omit the =true part, See:
Case(true,
[20 Yard Dumpster], 350,
[30 Yard Dumpster], 400
)
If you use a Case() function you can omit the =true part, See:
Case(true,
[20 Yard Dumpster], 350,
[30 Yard Dumpster], 400
)
 42 Points
Hello. I tried this formula, and it will only return the first value. The reason is because more than one statement can be true. Example:
Case(true, [Job Released], 10, [Paint Complete], 70)
Both can be true, but I want the field to return the value for the statement that has a higher value.
How do I do this? I am fine with using multiple if statements, but just don't know how to tell it that more than one statement can be true and to return "x" value if so.
Case(true, [Job Released], 10, [Paint Complete], 70)
Both can be true, but I want the field to return the value for the statement that has a higher value.
How do I do this? I am fine with using multiple if statements, but just don't know how to tell it that more than one statement can be true and to return "x" value if so.
 31,698 Points
When you want to prioritize the answer, make that the first evaluation in your daisy chain of IF statements.
If([Job Released]=true, 10,
If([Paint Complete]=true, 70, null))
If Job Released is true it will show that answer, and wont even check the rest of the formula. You can continue this as long as you'd like.
Good luck
If([Job Released]=true, 10,
If([Paint Complete]=true, 70, null))
If Job Released is true it will show that answer, and wont even check the rest of the formula. You can continue this as long as you'd like.
Good luck
 42 Points
Related Categories

Formulas & functions
 3036 Conversations
 81 Followers