I have a field generating an email for each person on a list: CONCATENATE( {First Name},".",{Last Name},"@Gmail.Com") This formula creates a First.Last@Gmail.com list in my "Resource email:" field.The issue is, when I create an automation to send an...
Hello,I want to hand executive leadership a simple tool to use as they are not familiar with Airtable like our Project Managers are. The workflow I am hoping for is a Gantt chart, that would auto filter when they select a record to look at. If I have...
I am looking for a way to calculate some percentages in my base. There are a few things I need to do first:1. I want to only include records listed as "Budgeted" or "Not Budgeted", not any "N/A" records. (this removes TEST 1 and TEST 4 from my calcul...
Hello,The {First Name} and {Last Name} fields are generated by a formula, not an automation, so they are already populated before the automation runs. The issue is, the automation isn't seeing anything and just filling in as if they are blank..
Thank you so much! I think I'm missing something here, but if I were to add more budget "TEST" records, how do I set them up to automatically link to the roll up to keep the percentage up to date?
