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

Answers

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



    Thanks,

    Aravind

    Associate Director

    Copernicus Consulting Pte. Ltd.

    P: +65 9230 5657 | E: aravind@copernicusworld.com

    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!