I have a workflow that processes upload templates, example attached. The users can enter data between columns D and K, but they have to fill it out for the entire column. In this example, they filled out columns F and G. I'm removing the columns that are fully null. However, I want to filter on the remaining to columns for rows with nulls. In this example, row 4 for PROD7777 to kick it out as an error. The problem I'm having is that users are able to fill out as few or as many columns between D and K that they would like. Is there a way for me to dynamically filter columns for nulls in columns that are partially populated after I remove null columns?
Solved! Go to Solution.
@Kristinbell - see attached workflow. Let me know if this is what you were looking for. Hope it helps!
That's perfect, thank you!