I have a checklist with about 30 items on it. Not all 30 items are required and sometimes, all 30 items may be required; pending situations determined by our employees. On each item, the results can either be Submitted or not Submitted.
Based on the requirements above, it gets messy if I'm going to check for each items (if it's required or not) and then to check results if it's Submitted or not using IF statements.
FN to check which are required, then loops through for the results? Just wondering if anyone has any better suggestions?
Thank you
Based on the requirements above, it gets messy if I'm going to check for each items (if it's required or not) and then to check results if it's Submitted or not using IF statements.
FN to check which are required, then loops through for the results? Just wondering if anyone has any better suggestions?
Thank you