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!