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!
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
