I need to create a field that will be populated with a "1" if two other fields (Field A and Field B) are also filled in as 1.
 0 Points
Posted 2 years ago
Ⲇanom the ultimate (Dan Diebolt), Champion
 30,204 Points
You don't specify what the value of the formula should be if [field1] and [field2] are not both equal to one and I am wondering if your fields are Numeric or Checkboxes.
If [field1] and [field2] are truely numeric you can use this formula:
If [field1] and [field2] are truely Checkboxes you can use this formula:
If [field1] and [field2] are truely numeric you can use this formula:
ToNumber([field1] = 1 and [field2] = 1)which will have a value of zero if [field1] and [field2] are not both equal to one .
If [field1] and [field2] are truely Checkboxes you can use this formula:
[field1] and [field2]which will have a value of true or false.(a Checkbox field).
 0 Points
They are numeric fields, but it's nice to know the formula for checkboxes as well. Thanks!
Related Categories

Forms
 3331 Conversations
 145 Followers

Formulas & functions
 3026 Conversations
 80 Followers

Relationships
 2666 Conversations
 50 Followers

Roles & permissions
 2256 Conversations
 25 Followers

Tables & fields
 7304 Conversations
 196 Followers