Comparison/Highlight help

kolfinna

Hello!

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.

https://publish.smartsheet.com/e356718b439e4b95bf900c012367d3eb

Thanks!

Paul Newcome

Try something like this...

=IF(OR(COUTIFS(Shortname:Shortname, @cell = Shortname@row, [Provisioned Space]:[Provisioned Space], @cell <> [Provisioned Space]@row)> 0, COUTIFS(Shortname:Shortname, @cell = Shortname@row, [Memory Size]:[Memory Size], @cell <> [Memory Size]@row)> 0, COUTIFS(Shortname:Shortname, @cell = Shortname@row, CPUs:CPUs, @cell <> CPUs@row)> 0), 1)