Link matching cells

sahilhq

Hi,

Is there a possibility in Smartsheet to somehow link cells that have the same text in the same sheet? For example, I already have a cell in row 89 with the text - "PAC289" and a new row entry with the same text has been inputted into the same sheet by a user. Any way of linking / higlighting the cells will do! I will have several such same cells in the future so it needs to be kind of a permanent solution and not just a one off clever link if you know what I mean?

Andrée Starå

Hi Sahil,

Here's an example that would check a checkbox if there is more than one of the same values in the column.

Try something like this.

=IF(COUNTIF(ColumnA:ColumnA; ColumnA@row) > 1; 1)

The same version but with the below changes for convenience.

=IF(COUNTIF(ColumnA:ColumnA, ColumnA@row) > 1, 1)

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

sahilhq

@Andrée Starå Hi, thanks for the response. Please see below a screenshot of the columns with the same text reference. I would like the checkbox in row 6 to be checked because PAC217 occurs twice. Can you suggest with a formula accordingly?

Capture.PNG

Andrée Starå

Happy to help!

Try something like this.

=IF(COUNTIF([PAC ID]:[Related pack reference]; [Related pack reference]@row) > 1; 1)

The same version but with the below changes for convenience.

=IF(COUNTIF([PAC ID]:[Related pack reference], [Related pack reference]@row) > 1, 1)

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

sahilhq

@Andrée Starå That worked, thanks! Can we also add another condition in the formula that if the related pack reference column is blank or N/A then any other value then checkbox column needs to be blank?

Andrée Starå

@sahilhq

Not sure I follow.

Can you describe it in more detail?