AVG (days until client) and if

Jörg Schmidt1

Dear Smartsheet Community,

I wonder how I can fix this issue:

I want to show in my dashboard the average number of days until a lead becomes a customer. So far, so easy. But I only need the cases above zero days

Would it be =AVG(Collect[interested since]; >zero

days until client.jpg

P.S. I cannot put the 2 brackets behind the above formula.

Jörg Schmidt1

Hi @Paul Newcome ,

just solved problem this way: Thanks for your help :-)

=AVERAGEIF(({Tage Leads}); >0)