Formulas | Airtable Community

Resolved! How to Format a Formula Field that pulls a Currency from another Formula Field

Need the 'Test Formula' field to format the 'Trip Total:' as currency. Any ideas anyone?

Screen Shot 2023-02-07 at 4.37.41 PM.png

Screen Shot 2023-02-07 at 4.38.06 PM.png

26 Views
1 replies
0 kudos

Help with Formula Syntax Please (Newbie)

Field 1: is a currency fieldField 2: a checkboxField 3: is a currency fieldI need a Formula in field 3 to do this: IF field 2 = 1, copy & paste the value in field 1 to field 3.Thank you.

54 Views
5 replies
0 kudos

Creating If statement formulas with a column that has both date and time

I have content creation table that has a field for date and time. I am trying to create a formula similar to this If ( {Date to Post}=TODAY( ), "Post") but it is throwing an error and I wonder if it is because my column has both date and time. this...

17 Views
1 replies
0 kudos

How to pull last element from Lookup field array?

Hi all! I was wondering if it's possible to use a formula to pull the last added item in a list of values in a Lookup field? The items are non-numerical so MAX(values) doesn't work. For context, there is a table for Members and a table for Posts. Pos...

26 Views
1 replies
0 kudos

Converting ISO date to European format date with leading zeros

Hi everyone,An application is sending me a date in ISO format (2022-02-13) and I want to convert it in the european date format without dropping the day and month leading zeros ( = 13/02/2022). I managed to convert from ISO to European but the leadin...

11 Views
0 replies
0 kudos

Manipulating Date data into the proper format

Hello,I have a web scraper that is pulling in assorted data from a list of projects. The issue being that the date/time data that it scrapes into my base doesn't convert very well into an actual date field type.Here is what I am working with:Any idea...

29 Views
1 replies
0 kudos

Field Reference Formula Error

I have a formula that works when a set decimal is entered but not when the decimal is inputted from a field reference. The formula that works (with manual decimal at the end): IF({Custom MSH Fee} > 0, {Custom MSH Fee}, ({Total Booking Price}+{Channel...

41 Views
1 replies
0 kudos

Turn list into a checklist

Hello i have a list of ingredients that are in a single long text cell SaSweet potatoCarrotI want it to put a ▢ infront of each item ▢ Salmon▢ Sweet potato▢ Carrot TIA

Screen Shot 2023-02-07 at 5.48.19 pm.png

44 Views
2 replies
0 kudos

Resolved! Date Formula Subtracting A day

Hi,Am using a formula I've used in bases before, but it's behaving strangely. It's subtracting a day off of the returned value. I have two fields with dates. Only one of the two will ever have a date in it. I want the formula to grab the date fro...

46 Views
2 replies
0 kudos

Resolved! Hide record ID not working in form prefill.

I am trying to follow this video tutorial: https://www.youtube.com/watch?v=BkAY7OHEgdcThe formula: 'https://airtable.com/shr12G6XKocbeGi0H'&'?prefill_Doll%20ID='&RECORD_ID()&'&prefill_Doll%20Name='&ENCODE_URL_COMPONENT({Doll Sculpt})&'hide_Doll%20ID=...

43 Views
3 replies
0 kudos

Calculate Number of Workdays Per Month

Hello, I'm stuck trying to figure out how many workdays exist in a given month. It is easy enough to get the number of workdays between a start and end date using the WORKDAY_DIFF() function, and it also seems possible to collect the total number of ...

79 Views
4 replies
0 kudos

Formula or automation to add one image to an attachment field

HelloWondering if someone can help me with something I am struggling with - but thought would be easy!I have an attachment field in one of my tables, and most records have upwards of 10 images. I'd like to set up a sync'd base which only shows the f...

42 Views
1 replies
0 kudos

Resolved! Show results by percentage from survey

Hi there smart people!I'm looking to show the percentage of improvement since the implementation of our new Figma redlining process from our team survey. Right now, 5/8 people say the process has either improved or greatly improved! Is it possible to...

94 Views
4 replies
0 kudos

Resolved! Count of records not adding up correctly

The bottom one should be a count of 2. Team A and Team B are two fields. I tried COUNT, COUNTA, COUNTALLHere's the formulaI can't even add a Count to that specific fieldThanks

94 Views
3 replies
0 kudos

Resolved! Multiple Select Formula for TimeSheet

Hello, Hope someone will be able to help me, I am trying to create a formula field for my employee to auto calculate his work hours for a day. He fills out the form and I am tired to calculate his hours per day.So, I've got one field "IN" with mul...

98 Views
6 replies
0 kudos

Resolved! Auto-populate Due Dates on work days only

I'm building a table with many due date columns and they all need to be automatically calculated based off of one "publication date." For example one due date might be 21 days before publication. BUT, I always want the due date to fall on a work day....

70 Views
2 replies
0 kudos

Formula to make bullet list from comma separated text

Can you tell me formula to make bullet list from comma separated text?eg text: "text1, text2".expected output:• text1• text2

77 Views
1 replies
0 kudos

Calculation for birthday - off by 1 day or not date formatted

I'm trying to create a date formula with the next/upcoming birthdate from a staff profile with Date of Birth. I need this to be formatted as a date so I can use it in a calendar, which has proven to be more difficult than I anticipated. Here are 2 wa...

96 Views
4 replies
0 kudos

IF statement for Payments

Hi, I'm building a formula that says if the first payment date is equal to the month today then show the first payment date otherwise show other payments with the month today.

62 Views
2 replies
0 kudos

I want to calculate how much of a service is is split monthly

I want to make sure the cost of the services is split according to the months it's meant to run. For example, a Product is $16,500 and will run for 6 months (Start in Feb, End Jul), so Product Per Month is $2,750. I want to create a formula that puts...

233 Views
11 replies
0 kudos