I am looking for the same rule like excel conditional formatting, highlight cell rules duplicate values.
I have employee number row, if the same employee number is entered, would like to highlight the numbers.
You would need a helper column that can be hidden after setting up that will flag duplicates. You would then create your conditional formatting rule based on this helper column being flagged.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
what is a helper column? Is that mean create another same columns that copy from the main entry then to detect duplicate?
It is simply a new column with some type of formula in it to "help" the sheet function the way you want it to. You could use a basic COUNTIFS to count how many times the number appears and then use conditional formatting on rows where the number in the helper column is greater than one.
=COUNTIFS([Number Column]:[Number Column], @cell = [Number Column]@row)
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
©2024. All Rights Reserved Smartsheet Inc.