Multiple bools for checkbox
I have a check box that previously was checked if X field was greater than zero. Now I need it to not be checked if Y field contains "random description". There are 38 random descriptions that have to...
Forum Discussion
I don't know which formula to use. Plus this site isn't approved so I have to do all of this on my phone.
An example:
Begins ([Related Unit], "BM60") will return all units beginning with BM60 to be"true". I need all of the units that begin with BM60 to be false. These are actual data names I'm working with and I have 38 units that begin with BM60 and 2024 that don't start with BM60. If the item starts with BM60, there is no charge for material even though the Related Unit has a price for material listed. So if it starts with BM60 the checkbox for material needs to be unchecked. Otherwise, for the remaining 2024 it needs to be checked. The "costs" are not visible to data entry so they would not be able to manually check the box because they can't see if there's a cost or not. This is why the check boxes have formulas. I hope that clears things up.
An example:
Begins ([Related Unit], "BM60") will return all units beginning with BM60 to be"true". I need all of the units that begin with BM60 to be false. These are actual data names I'm working with and I have 38 units that begin with BM60 and 2024 that don't start with BM60. If the item starts with BM60, there is no charge for material even though the Related Unit has a price for material listed. So if it starts with BM60 the checkbox for material needs to be unchecked. Otherwise, for the remaining 2024 it needs to be checked. The "costs" are not visible to data entry so they would not be able to manually check the box because they can't see if there's a cost or not. This is why the check boxes have formulas. I hope that clears things up.