SheilaAllas

2 years agoQrew Trainee

# Formula Help Request

I'm trying to create a formula that will read 6 different numeric fields and then decide which field to populate as a results.

If Numeric field 6 is empty, populate Number field 5

If Numeric field 5 is empty, populate Numeric field 4

If Numeric field 4 is empty, populate Numeric field 3,

If Numeric field 3 is empty, populate Numeric field 2,

If Numeric field 2 is empty, populate Numeric field 1

At minimum, Numeric field 1 will always have a value.

Any help you can provide is greatly appreciated. I've tried many things and nothing is working.

Thanks

Sheila Allas

------------------------------

Sheila Allas

------------------------------