Count # of Rows that have any number of attachments

Julian Graham

Hello Friends,

I am looking to measure what percentage of users upload or add an attachment for this I am looking to create a helper column that shows 1 if there is an attachment and 0 if there isn't then sum it up in a sheet summary. I can't figure out how to do that.

Thanks,

Julian

Jason Tarpinian

You can set up a workflow to change a cell value when an attachment is added, like below. Then just do a COUNTIFS() for the value that your automation would be changing.