Cell linking and formula


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)


  • 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.


    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⬆️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!