A formula in a calculation shows “Waiting…” when it needs more input from related fields to produce a result.
How to resolve a “waiting…” message
Ensure the following conditions are met:
Fields are not empty
An empty field is not the same as $0. Blank fields can prevent the formula from calculating. These fields are denoted with a '-'.
Fields are filled in correctly
Ensure:
Text fields contain text.
Number fields contain numbers.
Text fields use the correct answer format
Some fields specify a particular format, such as Yes/No. Using an incorrect format, like Y or N, may prevent the formula from working.
By addressing these points, the “Waiting…” message should resolve, and the formula will calculate as expected.