Predecessors #ref formula


I am building a template which requires users to delete un-required task rows. This then creates #REF in the predecessors box (along with the other predecessors)

I would like to highlight the predecessor box containing #REF but i cant get a formula to identify the data


  • Aravind GP
    Aravind GP ✭✭✭

    Hi Cameron,

    Since you just want to highlight, you can set up a Conditional Format as below to quickly see all rows that have this error.



    Associate Director

    Copernicus Consulting Pte. Ltd.

    P: +65 9230 5657 | E:

    Feel free to reach out for licenses, services, and training on Smartsheet

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!