Formulas

Hey friendsI want to check who has watched the videos on my system and I have some automation that was up until now transferring to Google Sheets and now I'm switching to AIRTABLE.If I want it to mark me with a V in the checkbox, what should I write?I would later like to add IF on the same simple checkbox and check the quality of a lead.Hope you understood.I'll be glad to receive your help,Thank you! 

Hey guys, I recently built a “Wellness Log” base in Airtable that tracks all kinds of stuff: When I get up and go to be every day, when I eat each meal, how much H2O I drink every day, how long between each meal, and star-based ratings of my mood, mental focus, and energy/stamina. What I have no idea how to do but really WANT to do is build formulas that calculate change over time using entries from other days. Specifically, I want to calculate the amount of sleep I’m getting every night, as well as net weight loss/gain since I started tracking my weight in the base. Regarding the nightly sleep calculation, I have a “RISE” and “BED” field in each record that is a Date field type that includes the time in 12 hour format. I want to create a formula to identifies the preceding record and calculates hours of sleep based on the amount of time between “BED” yesterday and “RISE” today. With the weight loss/gain I would need to ID the first record that has a valu

Hi there, I'm new to Airtable and trying to figure out how everything works. Let's say I have a cell that as the following information I inserted below: Ingredients- 4 salmon fillets- 2 tablespoons of melted butter- 2 tablespoons of olive oil- 4 cloves of minced garlic- 2 tablespoons of freshly-chopped parsley- Salt and pepper- Lemon wedges (optional)Instructions1. Preheat the oven to 375 degrees Fahrenheit.2. Place the salmon fillets onto a baking sheet lined with foil.3. In a small bowl, mix together the melted butter, olive oil, minced garlic, and parsley.4. Brush the butter mixture onto the salmon fillets.5. Sprinkle salt and pepper over the fillets.

Hey friendsI have 2 tables in one base.In one table I have a list of all my leads and in another table I have a list of those who paid money for the workshop I give.I want to make it so that in one table there will be a column that checks if the email of that lead exists in the other table of the payers and if so, to add a V in the checkbox.Is it possible?And if so, how do you do it?Many thanks to the best community in the world!

I believe I know the answer to this question (no) based on a search of past Community posts, including this one by @Jason_Hull that got expert replies by @kuovonne : is there a formula that can alphabetize referenced values? There are a lot of use cases for where this would be a helpful function. In my case, it's to list a different field's multi-select options in alphabetical order for an easier at-a-glance confirmation of the multi-select field's entries. Specifically, my source multi-select field has a looooong list of occupations and I'd like to build a formula field that lists the selections alphabetically.

It's currently 19:55 on the 21st december in New Zealand. Why does this calculation return a date of the 20th december and the time as 18:55? Surely it can't be that hard to show the correct date for the country you're in?  

Hey friendsI'm trying to create a rating for my leads in the system based on all kinds of parameters - if they watched video 1, if they watched video 2, etc. For some parameters, I want to create 2 stars and some more. As in the example, if the customer is marked V on Facebook, he should receive 4 stars because this indicates a higher rating.It doesn't work for me when I add the most stars.I would appreciate the help and understanding of what I am doing wrong here.Thank you! 

Hi everyone, I've got a set of criteria to score the program length that states the following: "A faculty-led program for any term is 3 points. An interterm program longer than 3 weeks is 3 points. A summer program longer than 6 weeks is 3 points. An interterm program longer than 11 days, but less than three weeks is 2 points. A summer program longer than 21 days, but shorter than 41 days is 2 points. An interterm program shorter than 11 days is 1 point. A summer program shorter than 21 days is 1 point. In translating that to a nested combination of IF(FIND(OR arguments, my syntax got off, or, alternatively, resulted in all points being wiped out or everyone being assigned 3 points. I've included a few versions of my formula text below. Should I be using a FIND( statement for each IF( statement?v1IF(   Find(

Hey friendsI want to create a star rating in the system based on V in existing checkboxes.That is, if you watched video 1 - one star.If you also watched video 2 - 2 starsAnd so on.How can you create such a thing?That is, an IF that depends on a checkbox.Thank you! 

I need to export a grand total number from Airtable to import into our payroll software as a csv.   The table is setup by an employee and that employee has a new row for each month of the year with a number in it.   I know that airtable sums those columns, but I don't know how to export the grand total by employee.   I need the grand total of the {Dollar$} field exported.  How can I do this?   Thanks. Wendy

Hi, I'm working on multiple views and 2 tables.When I filter a lookup/rollup, those filters are applied to all the views of that table. Is there any way I can "stop" the filter to only one specific view?I would like to avoid creating multiple tables for each filter.Thank you 🙏

Hello! I am new to using Airtable and am excited to learn about its capabilities. I am creating an event program and I would like to enter the start and end dates of each part of the program. Is it possible to automatically update the end time of each event based on the duration that I input? For example, if I enter a start time of 6pm and a talk that lasts 6 minutes, I would like the end time to be updated to 6:06pm. I would like to use this feature to see if any events are going over their allotted time. Can you help me with this?

Hello alls,I have a sum up column as shown in the picture above. Actually, I use excell for the calculation (I copy the value column in excell, I make the calculation of the sumup column in excell and then I copy back to the airtable sumup column). Hence, I'd like to know if it exist any function or script that could do this calculation directly in airtable. Thx 

Hi,I'm trying to work out how to display the difference between two dates as weeks, then days.As an example, one of our crew will be away for 9 weeks and 3 days. It is difficult for them to work out how long that is if it's only displayed in days (66) and in weeks it's not accurate enough.If I useDATETIME_DIFF({End Date},{Start Date},'w')Then anything less than one week displays as 0.0, and the extra days are not accounted for.Ideally I'd like to be able to display "9w, 3d".Any help working this out would be greatly appreciated.

Hi, I will be very grateful if you can suggest a solution to the problem. I am doing a lot of questionnaire surveys, the results of which need to be standardized. I don't know how I should do it using Airtable. Currently, I have created two tables. Table 1 shows the questionnaire survey results (ws_score) and table 2 shows the standardized results. What should I do (what formula?) to substitute the standardized score from table 2 (sten) into table 1 (sten_number)?  

It is currently the 18th Dec in NZ. The field I have called TodayNZ is a calc "Today()". It is formatted as NZ time zone. Is  there any reason why it comes up as the 17th Dec? 

I'm trying to randomly assign one of four Group IDs (AlphaGroup, BetaGroup, GammaGroup, DeltaGroup) to all existing/new records in my database whether they're imported in bulk or added manually. I've been using this formula—however since some of my records will be imported in bulk, their created time remains the same and gives them all the same Group ID). I also have First Name, Last Name, Email, and other fields that could potentially be useful here. Any idea how to address this? Thanks!  IF( SECOND( CREATED_TIME() ) < 15, "AlphaGroup", IF( SECOND( CREATED_TIME() ) < 30, "BetaGroup", IF( SECOND( CREATED_TIME() ) < 45, "GammaGroup", "DeltaGroup" ))) 

Hello everyone! I've made a table that works as a 'Recurring tasks' table. When someone finishes a job, they'll mark the job as done by using a checkmark (se picture). The task can either be a daily task or a weekly task. If it's daily the 'Daglig' checkmark will be used, if it's weekly, the 'Ugentlig' checkmark will be used. Depending on what's chosen the table will find the right "next due date". The thing is however: the table is grouped by the field 'Hyppighed' (how often a task is being made), so when a task is being checked, it will be moved to an 'Empty' group since 'Hyppighed' isn't automatically filled.  My question is: What should a formula look like in order for it to automatically fill in either 'daily' or 'Weekly' depending on what kind of task it is? I want this in order for the tasks to move to the right group again. Hope it makes sense.  

I've been trying to automate my CRM to automatically update the date of my last interaction with someone by linking my Outlook calendar meetings to records of people in my "People" table and then have the most recent meeting date show up in the People table under "Last Interaction".I tried adding a People column in the Outlook calendar table linked to the People Table with a lookup record to search for the contact in the attendees list based on their Primary Email but it's not pulling the people.Ultimately, I am trying to have the Calendar table search for the attendees based on their email in the People table, then update the records for the associated contacts column for "Last Interaction" in the People table.Any ideas on how to link the tables and automatically update the date of our last meeting without having to manually add the attendees?

Hello everybody! I am trying to create some buttons in a table with a lot of different information. It looks like this:   The issue is: right now every button leads to the same URL. I want each (or at least) some of the buttons to direct to other URLs within the same table. Isn't that possible?

I was setting a "Happy Christmas" automation. I could have set the automation time trigger to "YEAR-12-31", but using the last working day as a trigger is better. Firstly I searched on the community for this kind of formula. I could not find. So, I wanted to share with you.The weekday number of the 29th day is important, since if it is friday, this day should be trigger date, since 31th is sunday, etc. Also, if you have a better formula or find a problem in my formula, please share your comments. IF(AND(WEEKDAY(YEAR(TODAY()) & "-12-29") = 5, YEAR(TODAY()) & "-12-29" = DATETIME_FORMAT(TODAY(),"YYYY-MM-DD")),1, IF(AND(WEEKDAY(YEAR(TODAY()) & "-12-29") = 4, YEAR(TODAY()) & "-12-30" = DATETIME_FORMAT(TODAY(),"YYYY-MM-DD")),1, IF(YEAR(TODAY()) & "-12-31" = TODAY(),1,0)))   

Hello, from a booking days main table, I create a view for records filtered on the next day called D+1. Then, I create a "Tomorrow" table with one single row linked to the main table to make a summary by rollups of certain datas : clients list, quantities, and so on. For this link field, I choose the option "limit selected records to a view", which is the D+1 view. So I guess I’m just going to summarize the D+1 view filtered records, but... No ! The rollups summarize the ENTIRE main table without taking into account the view filter !I am not looking for a solution because I have already found others but I do not understand what the "limit selected records to a view" option is usefull for since this limit is not taken into account by rollups. Any ideas ?

Hi, I'm trying to merge two columns that have attachments. I have 1 column that includes the attachments where the user is the primary contact (1- Attachments- Purple Due in one week), and another one where he/she is the secondary contact(2- Attachments- Purple - Due in One Week). I need to merge those columns to create a "total attachments" column for users.The attachments are "white" because are just white pages of word (for now).I tried to use ArrayJoin, Concatenate and also &, but the result is the same.How can I solve this problem?? Thank you very much!  

Hi dear friends.I would appreciate your help regarding time differences.The clock should be +2 as you can see in the picture but for some reason when I do the formula it takes me back 2 hours and I couldn't figure out how to use the timezone formula.I would appreciate your help on how to write the formula correctly so that it works.Thank you! 

I thought I was being clever but my formula did not work. Cells are blank. Why?SWITCH(  {Decimal},  "0.75",  "3/4",  "0.50",  "1/2")