Field that counts.. based on data being present in other fields
I have 5 rows of data each with (weight, length, width, height). I’m trying to create a field called “pallet total” So if Row1 has data in (weight, length, width, height) I want that to count as “1”. If “row 2” has it fields not entered or only some of the fields entered I don’t want it counted.
The goal is to have Pallet total showing the grand total of pallets for shipment based on the rows with complete data. Any ideas? Thanks..