Hi I really need help for this and I have a deadline. So basically, I was wondering if there's a way that I can create a formula that add's up the number of time "" is used across all fields and shows the result as a number in the "s Used" field.. Fo...
Hi ,I am creating an airtable automation for recurring task for weekly, daily, monthly, 3 times per week and twice a month In the next to perform date i used this formula DATEADD({Due Date},SWITCH(Frequency,'DAILY',1,'WEEKLY',7,'MONTHLY',30,'TWICE A...
I have a complicated string of formulas that is setting due dates. The short of it is I have a "complete" column (checkmark) and "Date completed" (static field). A task is completed and marked with a checkmark in complete where it stays visible all d...
Hello! I am attempting to recreate some data I have in Google Sheet and improve my work flow. I am currently counting things by hand and it taking to long. What I am trying to do is create a "Master" sheet where all my info lives. But have a "Stats" ...
Hi, I have a column where the information is linked to a value in the same tab. I would like the information to be automatically filled with the information on the other line. For example on the screenshot, I would like to have John Doe in the cell f...
I have a Table that lists everyone who has taken our leadership courses (Participant table). Fields include Participant Name and FLL Attended.I have a second table listing everyone who is a salaried leader in our company (600 records). I want to have...
So, I have over 3,000 people in my database that people can opt in to help the charity in numerous ways like being: volunteers or subscribers or sponsors or trainers etc etc but some people has said they can help by doing a few of those options.My pr...
Is there an airtable formula that combines linked records from a column (say column 1) and another column (say column 2) and outputs it as linked records in column 3? If not formula is there a way to do this without scripting?
I have a date & time field.For example, below is the data. I will have a different date and time and 100 rows with data.1 Jan 2024 1:00 PMAt 1:00 PM on 1 Jan 2024, I want to send a Slack message using airtable automation.How can we make this trigger?...
Hello,I am very new to Airtable, and would love some advice or guidance bringing a few ideas to life. I am using Airtable for an applicant/candidate tracking system, interview scheduling, and job tracking for a recruitment firm.The current set-up is ...
