Column P is counting the how complete (by percent) a dataset is. Columns R, S and U are counting metrics from this dataset. I’d like Col R, S, & U to show “incomplete” until Col reads 100.00%. Is there a function I can wrap around my metrics functions to make this happen?

I’m not familiar with any functions that can do this except “iferror” which isn’t applicable here.