AVG (days until client) and if

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

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!