Cell linking and formula

Julie Barbeau
Julie Barbeau ✭✭✭✭
in Formulas and Functions

Is it possible to use functions like SUM and COUNTIF for cells whose data comes from a link in another cell? I'm trying but it doesn't work

My current formula is =COUNTIF([Priorité d'entreprise]:[Priorité d'entreprise]; "Red") and the result gives me 0 when it should be 2 (see image below)

image.png
· Share on FacebookShare on Twitter

Answers

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭

    Hi Julie Barbeau,

    Please try the below formula,
    =COUNTIF([Priorité d'entreprise]:[Priorité d'entreprise], "Red")

    I have corrected a minor syntax error. I hope it will work.

    Thanks,

    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

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

    · 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!