Sign in to join the conversation:
Hello all,
I'm trying to create a formula to "Autofill" contact (Name, phone number & Email),
What is the smartest, fastest way to create a formula for over 500 contacts?
Thank you
Create a table of your contacts and use a VLOOKUP function to search that table. It means a little extra work on the front end building the table, but once set up, a very basic formula will pull the info you need.
Thanks Paul, I'll give it a try
Is there a way to achieve this using the data that is already in my Contacts, rather than creating a whole new sheet of contacts with their information to perform a VLOOKUP or INDEX/MATCH on?
Hi @Ken Potts
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
