Hi, I’m trying to figure out how to do a count for number of approved and pending claims for each employee in sheet 1 and update the count number in sheet 2 in the attached images. I’m stuck in counting the total count and update in only row 1 instead and I got more confused.
Hi, thanks for helping. I’m trying to do a count for number of approved claim and number of pending claims for each employee. How do I convert the update in the workflow to number of claims instead?
I had edited to updatestatus.count in the IF activity and ran the workflow. The count is still not correct. How to I get the count? This is the file I edited using your workflow. (CountOfColumns.zip (19.4 KB))
Thanks so much for your help.
Hi, thanks for the workflow. I added some entries to try. How about if I have additional approval for the same customer? What should I do with the count? For example, after adding some more names, Arun should have 1 approval and 1 pending and happy should have 1 approval not 3. I attached the workflow for your help.CountOfColumns.zip (19.7 KB)
Yes, I’m still facing some problem as mentioned above. Another question is, what if there is another header such as this (junniest.xlsx (10.6 KB)
), how to do the count? Appreciate your help. Thank you.