Formulas

I have a base for timesheets. I have a column which is set to decimal for hours total called qty eg. 9.50 or 10.00. Then I have a formula that will accept the total hours or put something different depending on leave status abbreviation but it won’t write down the answer as a decimal or let me format it. So my formula is -if({status}=“on”,qty,if(and({status}=“lwop”),“0.00”,if(and({status}=“rdo”),”8.00”)))And for any of those combinations it comes out like eg 9 or 9.5 for “qty”, 0 for lwop and 8 for rdo Can you help me format into same format as my other column and formula examples. 

 I have a series of records that include a Start Date field that I want to incorporate into a larger CONCATENATE formula.  However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR.  I have tried adding an IF=BLANK statement to the formula (see example below) but that doesn't seem to be working either. IF({Start Date}=BLANK(),(DATETIME_FORMAT({Start Date},'ddd, MMM, DD') any suggestions on what to try next?

I need a formula to check if there is exact matching for multiple select field when values can have comma. Here is a sample multiple select I can have:abca,bI need to check if users selection is exactly 'c' and 'a,b'. All solutions I found (like using FIND) are not working with comma.

Hi All,I'm having an issue figuring out how to best format a formula for my situation. This is probably very simple but I need a hand. Here are my fields:"Total" - Currency field with numeric value"Total Copy" - Formula Field "Is Income?" - Single Select fieldBasically, I need Total Copy to take & convert Total's value to a negative or positive number based on Is Income.I have this so far to grab from Total and make it a negative: IF({Is Income?} = BLANK(), {Total} *-1, "") But now I need it to also recognize if Is Income is not empty so it can copy from Total and deliver

I know if I use a switch, I can write a formula to return a single value from different fields based on a given input from a single-select field. Like if the select field has options A, B, C, it’d be SWITCH({select field}, A, {Field A}, B, {Field B}, C, {Field C}).What I want to do, though, is have multiple inputs that return multiple outputs combined into a single text string. Is there a way to do that?I’m trying to show who needs to review a project on different rounds of review. Round 1 might need Role A and Role B, Round 2 might need Role C and Role D, and so on - I have that info logged in a definitions table. I also have assignment info for each project, like “On Project X, Role A is Alice, Role B is Ben, while on Project Y, Role A is Albert and Role B is Betty”. So then in the table where I list out the rounds of review that happen for my projects, I want to combine that info and have a “reviewer” field that returns the reviewer names, so like Project X’s Round

What is the formula to get the Time in hours and mins from a Date/time field?? My date/time field is called “Start”.

How can I do a word count of a record? I have a table to organize what I write divided by scenes and I want to count the words in every scene. Thanks in advance.

Heyo!I'm stratching my head as to how exactly format a formula down to first .00 numbers for an email automation.Inspite what I've attempted it continues to display all 13 numbers for "M1" calcuation. Screenshots attached.

Hi,I am using airtable base for my job. I visited persons and I have to repeat this visit every 2 to 4 weeks. When I finished my visit to customer,  I wrote in aitable base report and then airtable base recorded the day and time in the last modified field. Now I have my costumers who are not same level and I have a colon with numbers 14, 21 or 30 these numbers are a number of date which I heve to visit customers again. How I can do this in airtbale.example I was in visit of my costumer 1 septembar 2023, he is my important customer and I want to see him again after 14 days. I need formula in the fild where the Airtable will give me notification that I should see him 15 septembar 2023, Exemple 2 I was in visit of my costumer 1 septembar 2023, he is my not important customer and I want to see him again after 30 days. I need formula in the fild where the Airtable will give to me noti

I am importing customer support tickets from another database (Hubspot) in an attempt to calculate the following:1) What is the duration between each ticket date (single field) for the same product serial number? The goal is to understand the average duration (in days) between customer tickets for each product (serial number) sold. For example, if one product (serial number) has three ticket records (imported from Hubspot) - If the first ticket record has a date of 1/1/23, the second has a date of 1/4/23 and the third has a date of 1/8/23, it would return the dates of 3 days and 4 days between each sequential record. How do I get Airtable to calculate the date difference from the same field? 

Hi and thanks in advance for the help!I have multiple IF statements that I would like to include in one Formula field. Essentially what I want is the output to be in one formula column with the output being:Result from IF STATEMENT#1(line break)Result from IF STATEMENT #2IF STATEMENT #1IF(  {Requestor job level} = "Individual Contributor","🍅 Individual Contributor",  IF(  {Requestor job level} = "Performance Leader (Manager)","🍋 Performance Leader",  IF

Hello,I am looking to create a rollup field to display the next task due for a project.  What I would like to do is have the rollup field display the task name, but the formula should reference something like the MIN({due date}) in order to select which of the many tasks are due next?  Can't seem to make it work and am wondering if it's possible or if I'm going about it wrong?Thanks!

How to Create Formula that Returns the Data in Field 1 (if data exists), or Field 2 (if no data in field 1 and has data in field 2), Same for Sequentially Fields 3-5? I see there are several posts on how to choose a “text” result by writing that text in the nested IF statement. However, I am looking to return the data in field 1 (check this field first and return the data in field 1 if data exists in field 1), and if no data exists in field 1 move on to check field 2 (check this field next and return the data in field 2 if data exists in field 2), and if no data exists in both fields 1 & 2 move on to check field 3 (check this field next and return the data in field 3 if data exists in field 3), and if no data exists in all three of fields 1 & 2 & 3 move on to check field 4 (check this field next and return the data in field 4 if data exists in field 4). There are 5 layers through field 5. Thanks so much in advance for your insight and time! I appreciate it.

I want to display the week like a calendar, but this formula is returning week 1 as starting on a sunday instead of a week starting on a monday and finishing on a sunday, how can i alter this?VALUE(DATETIME_FORMAT(Date,'w'))-VALUE(DATETIME_FORMAT(DATETIME_PARSE('01'&DATETIME_FORMAT(Date,'MM')&YEAR(Date),'DDMMYYYY'),'w'))+1

Hi,I am making what to me seems like a simple change to a simple IF Formula. The prior version of the formula was: IF({Money Out},-ABS({Money Out}),IF({Money In},ABS({Money In})))This is the new formula. IF({Money Out},-ABS({Money Out}),IF({Money In},ABS({Money In})),IF({Debit or Credit},{Debit or Credit})) For some reason, even after I press "SAVE" after updating the formula, when I go out of the field and come back to the field, I see the prior version of the formula. I do NOT get any ERROR messages.  And tried repeatedly to update the formula. I have tr

I am sure it is quite simple, but for some reason, I can't find the way to do it.Let us say I have Table A. In the Table A, I have, amongst many others, a Date field.I also have Table B, with two fields in it. One field is a (unique) Date. The other field is just a number. Let us call it [Day Number].[Table A/Date] and [Table B/Date] are not linked.I just want [Table A] to look at its own [Date] field, then search for the corresponding [Date] in [Table B] and retrieve the corresponding [Day Number].Must not be very difficult, but I can't find the way! 

ROUNDUP is returning unexpected results.See screenshots, there are 3 records where ROUNDUP is increasing the value rather than truncating a '0' (I was expecting 0.070 roundup to be 0.07)  Is this an error, or am I not understanding ROUNDUP correctly?2nd screenshot added the FLOOR function as suggested in this pos, but had no impact to the results.: Solved: Re: ROUNDUP(number, 2) Incorrect rounding - Airtable Communitythanks for any insights!

Hi,I am currently getting an error message on this formula: {Contacts Clicked}/{Total Emails Delivered}*100 Does anyone know how I might fix it? Thanks.

I’m hoping someone might be able to help me figure this out… To put it simply I have one column full of images (just one image in each cell) but 1000’s of images total. I need another column, residing next to it that contains the URL for each image, and I haven’t found an easy way to do this aside from just copy and pasting each individual URL. Which gets very repetitive and time consuming doing this thousands of times. Is there a formula out there that could pull these image URL’s and fill each corresponding cell (to the right of the image cell) with the URL (of the image in the cell to the left of it)? Maybe I’ve just been looking at it for too long and there’s a much simpler solution?

Hello all,Brand new to Airtable and like what I see so far. I am trying to calculate a date from two sets of data.  In Excel I would have use Start Date + Duration - 1 to get the End Date.I thought I would use the Datetime_Format, but I am getting an #error!  I wrote DateTime_Format({Start Date1}+{Duration}-1, 'M/DD/YYYY')The Start Date1 is formatted as a Date US (9/5/2023)Duration is a LookUp field pulling from another tab in same base that is formatted as a number.I know this is probably something simple, but any help would be appreciated.  Also, a good recommendation for Airtable Resources. 🙂

Hello,Hope you guys can help me. I have a "Edition" field that contains three options: Extended, Standard and 360 Edition. The concatenate formula works however when adding the IF statement for the 360 Edition I get " Invalid formula." What am I doing wrong here? CONCATENATE({Order ID} & " " & Initials & " " &"Vol II") IF({Edition} = "360 Edition",BLANK()) Thanks 

Hi! I'm looking to create a formula where the "Due Date" is  7 days out from my "Send Date." However, I need a condition where if the "Send Date" falls on a Saturday or Sunday, the "Due Date" is automatically set to a Friday

I need to create a formula that will add 7 days to a manually entered date excluding Sundays and Holidays.--- This is an item that gets mailed, and I need to mail it 7-days before the "due date." Hence, no Sundays or Holidays.Any help or a point in the right direction would be most appreciated!

Hiya, I am fairly new to Airtable and have been tasked with setting up our CRM for the charity (HUGE JOB!) So... we have to get our dogs weighed roughly every month, but I need to be able to compare current weight with previous weight and how much the weight has either gone up or down. What I would like is when I come to enter a new current weight (in the {Current Weight kg} & {CW Date}(which is automatic date), the data that is already in those fields move to the {Previous weight} column and {PW Date} column (currently I am copying and pasting the data from current columns to previous columns before I enter the new current weight which is not ideal!.I then would like to merge my two formula columns {Difference} & {Difference in weight} into one formula so that all it basically shows is the weight difference and either a colorful up arrow or a down arrow emoji.... (oh and have the blank fields remain blank (not saying up!!) Can anyone help me d

Dear community,I have two tables, one called Supply and one called Demand, full of engineering information. There could be several Supply records that match the properties of Demand records.I am looking to create a formula in the Demand table that returns the cell 'Specific Material' from the Supply table records, for each Demand record, via IF AND OR conditions.I don't know whether this is possible, and below is my attempt referring to the Supply table via 'Supply.' then the Supply field name. The Demand fields referenced all show as purple, indicating that they are correctly identified, but the Supply fields are all still black.The conditions are all AND except for Supply.X material colour, which could be a match to either Translucent Colour or X Material colour in the Demand table. One of these should match as the last AND condition being met.Could anyone help me solve this via formula? I'd prefer a formula solution to a suggestion to use Lookup