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?

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Fairly new to Smartsheets - Having trouble with a countifs / date formula. Need your help!
I have a "master data" sheet that has a "DATE OF INCIDENT" field column, and a "FOUND ON A SCHEDULED INSPECTION" field column that populated as either yes or no. These are the two references I'll want to use in my formula on my metrics sheet. In my metrics sheet I want to use a COUNTIFS statement to tell me how many passed…
A workflow has become invalid
Hi, I received an email saying that one of the workflows of a particular sheet has been deactivated. The action for this workflow is so simple, so when the column in another sheet is changed as "completed" the row is copied and moved to a master sheet. It is important to mention that we have been using this for months and…
Permissions Workspace vs Sheet
I want to set a Workspace permission for all members (except Owner and 1 Admin) to Editor - Can Share, which I'm able to do. Within that workspace are some files that I want some of the members to have Admin permission, but still only have Editor permission for the other files in the Workspace. When I open the sheet for…

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