0

Formula doesn't work until I populate each field in the formula at least one time, then works for the one record. Needs to be repeated in each record?

I have a strange situation. I have 3 phone fields, Phone, Phone 2, Phone 3. I have a formula to then display the phone number somewhere else in the record (in the same table).

I want to display the most recent Phone number. If Phone 3 has no number display Phone 2, if Phone 2 has no number display Phone.

if 'Phone 3' != 0 then
'Phone 3'
else
if 'Phone 2' != 0 then 'Phone 2' else Phone end
end

The Formula works BUT only if I populate Phone, Phone 2, and Phone 3 at least one time. If a record has only one Phone, the formula field to display the number doesn't display the number from Phone until I populate Phone 2 and Phone 3 at least one time Once I do this it then works for the one record. 

If I open another client record, the phone doesn't display in the formula field until I populate Phone, Phone 2, and Phone 3 at least 1x for that individual record.

Any help is appreciated. 

Thanks, Pat

 

Phone formula visual

 

Phone Formula Text

3 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    You should use null instead of 0 like

    if 'Phone 3' != null then

    Steven

    • Fred
    • 3 yrs ago
    • Reported - view

    Try putting null instead of 0 if you are looking for empty fields.

    if 'Phone 3' != null then 'Phone 3' else if 'Phone 2' != null then 'Phone 2' else Phone end end

    • Patrick.1
    • 3 yrs ago
    • Reported - view

    Thank you both! This worked. Thank you :)

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 261Views