How to pull data from "Reference Another Sheet" from countifs between the time range

Ozu
Ozu ✭✭✭
in Formulas and Functions
image.png

Can anyone know what is wrong with this formula?

· Share on FacebookShare on Twitter

Best Answer

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Answer ✓

    Hi Ozu,

    Can you please explain which column/cell you are referring &Date(2022,916). It seems it is not referring to correct information.

    It would be helpful if you can share some more details.

    Thank You

    Kaveri Vipat, Smartsheet Engineer, Ignatiuz Software

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

    · Share on FacebookShare on Twitter

Answers

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Answer ✓

    Hi Ozu,

    Can you please explain which column/cell you are referring &Date(2022,916). It seems it is not referring to correct information.

    It would be helpful if you can share some more details.

    Thank You

    Kaveri Vipat, Smartsheet Engineer, Ignatiuz Software

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

    · Share on FacebookShare on Twitter
  • Ozu
    Ozu ✭✭✭
    edited 09/22/22

    @Kaveri Vipat

    Return Collection Date is the column I am referring to

    image.png


    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!