2 Lists to Compare

MarkSanDiego

MarkSanDiego ✭✭

03/27/23 in Smartsheet Basics

I have 2 lists to compare. One list has 1600 company names and the other list has 600 company names. Can SmartSheet compare the two lists and determine how many of the 600 are on the 1600 list? The common field would be the company name.

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

03/28/23

Where exactly are you wanting to put this formula?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
Multiple Selection in drop down or buttons on forms
There should be a way to select multiple options on a form when choosing from a list.
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…

Help shape the future of Smartsheet.
Share your ideas and feature requests.