Cross sheet referencing


Hi All,

I hope you're well.

I'm wondering if you can help me with my issue.

We have a RAID log for all the issues/risks on our projects. On the log, they are being identified by job numbers. We also have our main master tracker with all the projects on it. On the master tracker, there also is a column named job numbers - using same numbers as the RAID log.

Is there any way of creating a link/using a formula to ask smartsheet to highlight the cell in a certain colour on the master tracker if the same job number appears on the RAID log so by looking at the master tracker we can straightaway see which jobs are at risk?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!