HubSpothas two list types. One that accepts manual additions, one that runs on filters. The way each list type works contradicts each other. Filters would contradict manual additions/removals. That's why it's not possible directly.
If you want to be able to add companies manually, let's assume you have active list A. Create another static list B. In your list A, create another filter "OR company is member of list B". You can now add contacts to list B and they'll automatically enter list A.
@KJonsson, I found a much cleaner solution. Simply create a Static List and choose really any filter (you'll delete it in a minute, so try adding one you know doesn't have a ton of results). Once the list has populated all your results, you can select all companies and remove them from the list. Since it was a Static List, the companies will not be re-added, and you are now free to manually add companies to the list.
Now just go to your Companies object, manually search for the company you want, select the option "Add to static list", and select the list. Done!
Secondly, you can add companies by simply filtering for their company domain name or record ID. When you think about it, it shouldn't be possible to add single companies to an active company list as that would cause all kinds of conflicts for the list filters. If a list filter conflicts your manual addition, what should the list filter do? Ignore or override your manual addition? That's likely why HubSpot isn't allowing this.
OFAC publishes a list to identify persons operating in sectors of the Russian economy identified by the Secretary of the Treasury pursuant to Executive Order 13662. Directives found within the list describe prohibitions on dealings with the persons identified.
The FSE List is not part of the Specially Designated Nationals (SDN) List. However, individuals and companies on the FSE List may also appear on the SDN List. FSE List targets will appear in OFAC's Sanctions List Search tool with the program tag beginning with "FSE-" and "Non-SDN" as the list type.
Section (b) of General License 4 issued pursuant to the Global Terrorism Sanctions Regulations (31 C.F.R. Part 594), the Terrorism Sanctions Regulations (31 C.F.R. Part 595), and the Foreign Terrorist Organizations Sanctions Regulations (31 C.F.R. Part 597) authorizes U.S. financial institutions to reject transactions with members of the Palestinian Legislative Council (PLC) who were elected to the PLC on the party slate of Hamas, or any other Foreign Terrorist Organization (FTO), Specially Designated Terrorist (SDT), or Specially Designated Global Terrorist (SDGT), provided that any such individuals are not named on OFAC's list of Specially Designated Nationals and Blocked Persons (SDN List).
In order to uniquely identify these names, OFAC has created the program code [NS-PLC]. The prefix "NS" stands for "non-SDN". NS-PLC List targets will appear in OFAC's Sanctions List Search tool with the program tag "NS-PLC" and "Non-SDN" as the list type.
The CAPTA List contains identifying information of FFIs for which the opening or maintaining of a correspondent account or a payable-through account is prohibited or is subject to one or more strict conditions pursuant to the authorities listed below.
The CAPTA List is not part of the Specially Designated Nationals (SDN) List. Information that appears on the CAPTA list will be included in the data formats associated with the Consolidated Sanctions List.
Upon the imposition of less than full blocking sanctions or blocking prohibitions subject to a statutory exception for the importation of goods, as provided by statute or other authority, OFAC will place the name and other relevant identifiers of the sanctioned person on the NS-MBS List. The NS-MBS List also will specify the type of sanction or sanctions imposed on the listed person and the legal authority under which the person is sanctioned.
The latest changes to the NS-MBS List may appear here prior to their publication in the Federal Register, and users of this list can rely on changes indicated in this document. Such changes reflect official actions of OFAC or the Department of State and will be published as soon as practicable in the Federal Register. Users are advised to check the Federal Register and this electronic publication routinely for additional names or other changes to the NS-MBS List.
Information that appears on the NS-MBS List will be included in the data formats associated with the Consolidated Sanctions List NS-MBS List targets will appear in OFAC's Sanctions List Search tool with the program tag beginning with "CAATSA - RUSSIA" and "Non-SDN" as the list type..
Information that appears on the NS-CMIC List will be included in the data formats associated with the Consolidated Sanctions List. NS-CMIC List targets will appear in OFAC's Sanctions List Search tool with the program tag beginning with "CMIC-EO" and "Non-SDN" as the list type.
The list below is updated continuously by Jeffrey Sonnenfeld and his team of experts, research fellows, and students at the Yale Chief Executive Leadership Institute to reflect new announcements from companies in as close to real time as possible.
When this list was first published the week of February 28, 2022, only several dozen companies had announced their departure. We are humbled that our list helped galvanize nearly 1,000 companies to withdraw in the time since.
Although we are pleased that our list has been widely circulated across company boardrooms, government officials, and media outlets as the most authoritative and comprehensive record of this powerful, historic movement, we are most inspired by the thousands of messages we have received from readers across the globe, especially those from Ukraine, and we continue to welcome your tips - preferably with documentation - as well as your insights, and feedback, at
jeffrey.son...@yale.edu.
Click here to watch President Zelenskyy's interactive Q&A, hosted by Jeffrey Sonnenfeld and live-streamed by CNBC, with over 150 top US CEOs at the Yale CEO Summit, and click here to read about President Zelenskyy's key lessons for business leaders. Click here to watch President Zelenskyy's interactive Q&A with Yale students, hosted by Jeffrey Sonnenfeld.
Click here to read our recent SSRN working paper on how "Business Retreats and Sanctions Are Crippling the Russian Economy", and click here to download the accompanying slide deck presenting this data visually.
Updated By: Jeffrey Sonnenfeld and Yale Research Team: Meena Ambati, Adam Arcichowski, Wiktor Babinski, Will Berkley, Ahaan Bhansali, Yash Bhansali, Forrest Michael Bomann, Michal Boron, Tristan Brigham, Jesse Bross, Adnan Bseisu, Katie Burke, Lauren Cho, Cara Chong, Andrea Chwedczuk, Adriana Coleska, Maia Cook, Cam Coyle, Khulan Erdenedalai, Paola Flores Sanchez, Jake Seymour Garza, Kevin Grold, Tamara Gruslova, Hunter Harmon, Patrik Haverinen, Georgia Hirsty, Warner Hoshide, Daniel Jensen, Aditya Kabra, Nolan Kaputa, Mateusz Kasprowicz, Jay Kauffin, Sahana Kaur, Yuto Kida, Ava Leipzig, Victoria Liando, Cate Littlefield, Kasey Maguire, Marek Malinowski, Maksimas Milta, Rmi Mot-Buonaparte, Atin Narain, Christophe Navarre, Marina Negroponte, Camillo Padulli, Jeremy Perkins, Katya Pinchuk, Yevheniia Podurets, Aranyo Ray, Dorothea Robertson, Eleanor Schoenbrun, Nick Shcherban, Charlotte Simonds, Franek Sokolowski, Andrew Sonneborn, David Sun, Christopher Sylvester, Steven Tian, Maria Trybus, Umid Usmanov, Ryan Vakil, Daria Valska, Bryson Wiese, Chris Wright, Michal Wyrebkowski, Nicole Xing, Lara Yellin, Israel Yolou, Steven Zaslavsky, Nick Zeffiro, and Grace Zhang.
How We Do It: We have a team of experts with backgrounds in financial analysis, economics, accounting, strategy, governance, geopolitics, and Eurasian affairs with collective fluency in ten languages including Russian, Ukrainian, German, French, Italian, Spanish, Chinese, Hindi, Polish and English, compiling this unique dataset using both public sources such as government regulatory filings, tax documents, company statements, financial analyst reports, Bloomberg, FactSet, MSCI, S&P Capital IQ, Thomson Reuters and business media from 166 countries; as well as non-public sources, including a global wiki-style network of 250+ company insiders, whistleblowers and executive contacts.
I have an external Excel spreadsheet with a list of companies attending an event. I have matched this against our Hubspot database to see which Companies we currently have as records (so we can email them to tell them we are at the event).
I have a list of Company Record IDs that I want to email (around 300 records). But when creating a list, there is no way of adding a large amount of Record IDs to the filter to create the list.
Alternatively, I have also tried re-importing using only Company RECORD ID so I can then create a list. But it doesn't let me do it.
We come across this requirement a lot, but there doesn't seem to be a streamlined and clear way to do it.
Yes. This is what I have been searching many times for. A combination of the semi colon and create a new property and workflow has solved this issue.
Would be great if Hubspot implemented something to avoid the slight 'hacky' nature of this issue.
Today, the Department of Defense released an update to the names of "Chinese military companies" operating directly or indirectly in the United States in accordance with the statutory requirement of Section 1260H of the National Defense Authorization Act for Fiscal Year 2021.
3a8082e126