Intersecting Contacts and linked data

Hi there, thanks for all the contributions here - I already have solved so many issues. I'm stuck on one and hoping someone can think of a workaround:

In one row I have multiple contacts assigned in a contact type and I want to highlight the cell that intersects with another column. In this instance, its because I need them to insert the hours for that person in the box, but they tend to mess up the rate numbers if they aren't prompted (there are 13 of them). So ideal is if it highlights which boxes they need to complete, based on the contacts they listed. Is there a workaround or solution for that?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!