Formulas

(sad to see there is no "formatting" category nor a label for this, so posting this within "Formulas")I need to base the currency of my field Goals to reflect the currency of the continent the deal is in.As in "When the deal is in Europe, show the currency as €, however when the deal is in the USA show $"

Hi all,I'm wondering: Do any of you Airtable experts have an idea how I could calculate how many Fridays (or any other weekdays for that matter) there are in a given month?

Dear All,Im trying to create a formula where if an someone starts before the 15th of the month then return the 1st of that month. If they start on the 15th or after then return the 1st of the following month.I have created the below nested IF statement but only the first IF statement appears to be working. For start date equal to or greater than the 15th it is giving me the 1st of the month and not the first of the next month.Please advise  IF(DATETIME_DIFF({Role Start Date},'days'<15),DATEADD(DATETIME_FORMAT({Role Start Date},'YYYY-MM'),0,'months'),IF(DATETIME_DIFF({Role Start Date},'days'>=15),DATEADD(DATETIME_FORMAT({Role Start Date},'YYYY-MM'),1,'months')))  

Hi I have a multiselect that I have parsed out the individual answers to (they are ranked choice votes basically).I want to total the votes, and haven't figured out how to do that though I suspect Rollups and conditional counts could work, this will be a constantly changing tally and constantly updating the linked fields with new voters would be a hassle. This could happen either by talllying the multiselects or the Text fields which have the extracted Individual selections (derived from the multiselect).Currently looking at interfaces is the only straightforward way to do this. Would greatly appreciate any help. Obviously it's doable but seems like itll need an indirect workaround.

HITrying to compare URLs in a Search records module in MAKE.Want to find the 1 record where the URL in the table equals a URL passed from a previous module in MAKE.Can't get it to work.... the formula in AT directly does work, but within MAKE, it simply does not. Added the trim function just in case, tried with the URL as URL field and as text field in AT.... tried with typing = and with the = operator sign in MAKE. Nothing seems to work. Where am I going wrong here?{{if(trim(11.uri) = trim("{Record URI}"); 1; 0)}}Thanks!

I have a formula that worked but I decided to go and mess with it.I have a Date field that is the date of the task actionI have a Days to next action field to add to Date field to define next time to attempt the task (normally a callback)I have a Next Task Date formula field that shows the Date for the next task based on Date + Number of Days  - and it was nicely workingThe formula in the Next Task Date field looked like this - DATEADD({Date }, {Days to next action}, 'days')However I don't want the formula to put anything in the Next Task Date if the Numbers of days is blankHere is my current formulaIf ({Days to next action}=BLANK(), DATEADD({Date }, {Days to next action}, 'days'))It's failing and I can't figure out why.Thanks in advance for helping

Hi everybodyHow could I solve my problem, which is not so complicated, but I am running circles and can not find a solution... I would like to manage installment payment for some of my bills, with fields like Bill, Payment_rate, Rest_of_the_Bill,  The first 'run' is OK, but when I am trying to enter the second Installment for the same Bill, there comes a problem,,, I can not find a way to update the 'rest_of_the_Bill number.Thank you for any thoughts

I don't know if this is possible, but it will save a lot of time if it is. I have a donor database where each donor is known by their full name, ie. "Kate Jacobs". Is there any way that I can add a column with some sort of formula that could just pull the first word from that record? For the purpose of mail merge - I want to be able to do a FName tag, but currently will have to manually go through and rename all the contacts.  

I'm creating an inventory checkout database, based on a sandbox version created by another community member, and am trying to figure out a formula to indicate if items are overdue. Our default check-out time is one business day, and I've managed to create a formula that auto-populates the default due date, and a formula (below) that will indicate if an item is overdue, past that default dateIF(AND({Type}="Checking Out",IS_AFTER(TODAY(),{Due Date})),'OVERDUE') BUT the issue I'm encountering is that sometimes, we extend checkouts in special circumstances. I've created an "Extended Due Date" field, so that staff can manually create an extended due date if needed. However, I'd now like to figure out a formula for this Overdue field that would tell Airtable to first check the Extended Due Date field, and use that if it's populated, and then, if that field is empty, check the Due Date field. How would I do this? Thanks in advance!

I am creating a record keeping system for our market garden. Part of what I am trying to automate is a crop plan that generates a sowing calender - e.g. if tell my system I want to transplant 2x 10 metre rows of Cabbage in April, then Airtable will tell me I need to sow 1.5 trays of Cabbage in mid february in the nursery.I am however having trouble bringing collating data across multiple records. Say that I want cabbage in 4x beds on the same dates in April, each bed may be 0.75 trays of sowing. Because the information is stored against a record which is "Crop + Date + Bed + Row" - there isn't an easy way for me get "oh, I need to sow 3x trays on x date" without manually calculating "4*0.75."I would like to be able to automatically create a record that is a task for x sowing date that would say "3x beetroot"Is there a way to sum a column that is grouped by conditions (in this case, date & crop) in a formula field?AlternativelyObviously I could have a field that specifies how many t

Hi All-I am looking to have a conditional field in grid view so that if we are approaching an expiration date, the field will change color according to how soon- e.g. using (TODAY) red if 30 days from expiry, yellow 60 days, green 90 days. So far, I am not having luck with the IF formula in the condition field.

I can't get this formula to work.My table has 3 fields:Agreement SignedWYNTK SignedIntake FormEach field has a single select option, "Yes" , "n/a" or "In Progress".I have a final field "STATUS" with a formula - should all three fields = "Yes" or "n/a" =  "✅" If any one of the fields = "In Progress" then the STATUS field = "❌"   IF(   AND(     {Agreement Signed}="Yes",     {Agreement Signed}="n/a",     {WYNTK Signed}="Yes"     {WYNTK Signed}="n/a",     {Intake Form}="Yes"     {Intake Form}="n/a"   ),   "✅",   "❌")

Hello! I need some help from this community because I lack the knowledge to develop formulas.  I really appreciate your help.I'm trying to create a view for a database where I only see records where the answer for "Dates Available" is exactly between one month ago and 3 months from now.  How would I go about making this?Many many thanks in advance.

Hello Airtable Community. I created a Base to track my to-do list using several formulas and automation to reoccur each "done" task based on the set frequency of the task. For example: if the task frequency from the drop-down list is "weekly", then I created a formula that it will only reoccur weekly. However, if I want the task to reoccur on certain and multiple days of the week (e.g.: Monday, Wednesday & Friday), is there a way to do that without creating the task three times?Appreciate your support,Hamda

Hello everyone,I'm having trouble formatting a lookup field in Airtable. Specifically, I have a "Price (Lookup)" field that I want to separate using line breaks instead of commas (in a new "Price 2" column), as I plan to use this column for a table in Page Designer. However, the currency format is being lost in the process.Does anyone have any tips on how I can achieve this while maintaining the currency format?Thank you in advance for your help!  

Hi Community,I am looking to have a total sum of 1 column to reflect on a row that will match item number for another tableIf you look below at the snapshot images, the 1st table provides assessments for sites and I formulated a square yard number under each column (C202(52)(C) - Removal and Disposal of Existing Portland Concrete), (C202(52)(D) - Removal and Disposal of Existing Sidewalk...I am looking to have these total summed up quantities to reflect another table as shown on the second image, under the Total Assessment QTY linked accordingly to the item numberAny advice would be greatly appreciated!!!     

Hello Everybody,  I need some help with formula, so here is what I have, I have a "Multiple Select" field, lets say I have options like these there: Option A, Option B and Option C. Every option has its own price, let's say Option A is $10, Option B is $20 and Option C is $30. I have another field "Price", which is currently set up for "currency" and I manually enter the total there every time. So I want to use a formula to have a total sum of the options that I choose in Multiple Select Filed, any ideas? Thank you in advance

 Hey everyone,I am fairly new to Airtable so I hope it's not too nooby of a question.I am intending to create a fact table with invoices. Now I would simply like to aggregate the value for each client. The only way I found is the "group" feature, however this appears to me as just being a visual filter. In any case I need both the individual table as well as the grouped overview.Also I found that I can link records to each other but the actual grouping column is a formula. As soon as I select it as lookup, that is breaking the formula.How can I possibly achieve that?Kind regards,Marcel

Hello,I need to calculate a date. Here is an example:Start date of employee is 2023-05-03. The previous Monday, an email should be sent to the employee.How can I calculate the date based on the weekday.I have a formula, but it only works if employee starts on a MondayCheers

Hi, I'm looking for some help with a rollup that is rolling up start dates and returning the earliest date from a table. The aggregate function seen on the image is not taking into account the filter I'm trying to apply. I'm trying to return the earliest date on a roll up where the Session Name is not Session Zero. I do I do this in the formula ?  

I have 5 free form data fields, none of them are required. I need to display only the ones that receive data, and exclude the blank ones. How would I create that formula?

Hello all, I am trying to use the WORKDAY_DIFF Formula but it is returning #ERROR and I am struggling to determine why.  The IF,AND piece is working, the WORKDAY_DIFF is not (on its own or with the rest of the formula). IF(  AND({DateSubmitted}, {DateCompleted}),    WORKDAY_DIFF({DateSubmitted},{DateCompleted}))My fields are set to ISO dates. DateSubmitted is the Created Time auto value, and the DateCompleted is a formula - IF(Status="Done",NOW())Any help you can provide would be much appreciated. Thank you! 

Hello,  I'm current working with this formula: WORKDAY({Start Date},{SLA Test})   ---which is the formula in the 'due date' column.I would like for the Due Date to be left blank instead of #Error if there is no start date or SLA.Can someone help with an additional formula that I could add to the one above? Thank you. 

Dear community I’m a nubee here. Trying to schedule a non profit festival.Is there a formula for getting start and end time into the same column? Such as: DATETIME_FORMAT({Start Date},'dd. DD. HH:mm'), which is already pretty good. This gives me ie.: Mo. 25. 09:30I would for the sake of sharing like to include the {End time} ie (11:15) to get this appearance:Mo. 25. 09:30-11:15 Is there a formula to do this?I tryed DATETIME_FORMAT({Start Date},'dd. DD. HH:mm')DATETIME_FORMAT({End Date},'HH:mm'), but it does not work.Hoping for an answer.🙏 Uffe from KlaDa 

Hey All!I'm sure I'm overlooking a tiny detail, but here goes.My existing formula is:DATETIME_FORMAT({Date and Time},'MM-DD-YY h:mm a')&" GMT"&" - "&{Course Name}The documentation shows to add a timezone, to do this:DATETIME_FORMAT(SET_TIMEZONE("07/10/19 13:00", 'Australia/Sydney'), 'M/D/YYYY h:mm')My take, that doesn't work, is this:DATETIME_FORMAT(SET_TIMEZONE({Date and Time},‘America/New_York’),'MM-DD-YY h:mm a')& “ EST”& {Course Name}Can anyone tell me what I'm doing wrong?