Comparison/Highlight help


Trying to figure out the best way to compare data for some servers.

What I want to do is something like: for all rows where [Shortname] is identical, compare [Provisioned Space], [Memory Size], and [CPUs]. If there's a mismatch, highlight the cell.

Is something like that even possible? I want to compare prod and uat environments between two locations for servers that have had resource increase requests submitted at site A.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!