Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to link a column to another sheet so I can run a formula on duplicate values?
Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added or deleted.
I considered a report, however that would only accomplish part of the job, as I want to filter the results. I dont think there is a way to flag duplicates in a report.
What I am looking for is to see a list of all duplicates from a single column. I tried doing that as a formula in the original spreadsheet, however it became unmanageable as the formula was comparing values from about 4000 rows and it slowed down the sheet so much it was unuseable.
So here is what I need, broken down:
1. See all duplicate values (words, not numbers) in a single column
2. The values in this column, as well as the number of rows in the column, is going to change over time- so linking individual cells to a new smartsheet is not going to work. It needs to update dynamically
3. The Duplicates can be reported in a report or separate smartsheet in order to keep the original document clean and responsive. Keeping the formula in the original file was causing it to slow down too much.
a. The formula I have been using is a variation on this one- there may be a more efficient way to do this that I do not know of.
4. This duplicate list will be accessed and reviewed on a regular basis; but not every day or every week- so if it takes a long time to load and review, that is fine. We will just deal with it. As long as it automatically updates with all values from the column, we will be fine.
Any ideas on how to do this?
Thanks for any help!