AVG(cOLLECT(

Options

=AVG(COLLECT({Case Consultation Tracker Range Investable Assets}, {Case Consultation Tracker Range Investable Assets}, <100000))

Above is returning a number over 100,000.

Same issue for =MEDIAN(COLLECT({Case Consultation Tracker Investable Assets}, {Case Consultation Tracker Investable Assets}, >=500000 < 1000000, {Case Consultation Tracker Submission Year}, =2024))

Returns a number below 500,000. 😓

Answers

  • IEPE
    IEPE ✭✭
    Options

    HOLA, PRUEBA CON:

    =AVG(COLLECT({Case Consultation Tracker Range Investable Assets}, {Case Consultation Tracker Range Investable Assets},@cell <100000))

    ESPERO QUE TE AYUDE.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!