Hi everyone,I'm trying to solve a workflow/formula problem I've run into.Goal: I am building a task tracker, and it's important we have a history of steps already completed for each task. I have built a table that lists the tasks, and one of the colu...
Hmm, I feel like this should be easier, but I'm running into a stumbling block.I have a Multiple Select column {Dubbing VO (all languages)} that has a list of VO actors. Each name begins with the two letter code for what language they are working in....
Hello everyone! I'm attempting to construct email and Slack automation to remind my team to update specific projects (records) in a project management interface. When we were in data mode, I merely included a link to the Record URL in the automation ...
Hello Airtable friends.I have a somewhat simple formulaic excel sheet that becomes very complicated when breaking it up to be used in Airtable.The goal:Based on the type of sale, each of 6 static 'sale stages' should have defaul percentage (out of 10...
Hello Community! I need some guidance... I have a few columns with fields that are Single Select and one of the options is "COMPLETED". I am looking for a way to create a formula for it to add "how many COMPLETED fields" I have for that record... For...
I hope this is the right place for this question, but we'll see!Context: We have a 'Tasks' table where each team member may have a list of hundreds of tasks (thanks to the joys of generating task templates). I would like to have a View for users that...
I have read a few discussions on Unique filter - lookup then roll up. But i really can't seem to figure it out. I have my calendar synced - then I have a column of attendees, which is linked to companies. So each row has the different company in the ...
Hello everyone, Pretty new to Airtable but I am enjoying the platform and the features it offers. Currently I have a table with data for when we last saw specific people. The date is being entered as February 13, 2023 for example and I am converting ...
Can I use the switch formula to choose between the values of two fields based on whether a checkbox field is checked? I have 3 relevant fields in this table:{Contract Amount (distinct)} - a simple currency field showing the amount for this distinct r...
Hi everyone,I’m looking to incorporate the tracking of SLA’s into our base to measure performance against timestamps. Currently I have a table of all our SLA’s with descriptions and numeric values for the SLA which will be used in the calculation. We...
