Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

connection of softr and airtable.

we have a problem with the connection of softr and airtable. We have a part in softr where people can add new data and we need that data to be in airtable. However, in airtable the place where the data should go to is linked with other tabs.Since it’...

  • 3 Views
  • 0 replies
  • 0 kudos

Count number of times a word comes up in a linked records list

How can I count the number of records in the list "Attended Session & Challenge" that are specifically only from 2023? The attendance is based on a form they fill in that is in a different tab in the same workspace. help would be very appreciated! Th...

Screenshot 2024-02-26 at 11.40.05.png
  • 6 Views
  • 1 replies
  • 0 kudos

Return multiple values from all columns which meet criteria

Hi all,I have formulated columns Apple, Orange, Banana, and the formula produces "Y" or "N" values. I want to create another column that will return the name of the column if their value is "Y". Is there any way to do this?I have tried nested IF form...

Screenshot 2024-02-26 at 4.02.13 PM.png
  • 36 Views
  • 1 replies
  • 0 kudos

Linked two Tables with filter function

I create a form (interface in Airtable) to collect information from user and store in "Table A". Output fields include "Age", "Location", "Claim", "Special", Compo". I have another "Table B" to have above 5 fields and addtional "diagnosis value" fiel...

  • 48 Views
  • 3 replies
  • 0 kudos

Pulling Max Value

I have a table where different group clients submit weekly weights on a form.I'm calculating "starting weight - weekly weight = X". With each submission, I send them an automated email that records what their weight loss is, BUT even though their wee...

  • 76 Views
  • 1 replies
  • 0 kudos

Format date fields

Hi everyone, would you please tell me how to convert a multiple date string field (i.e., 2/11/2024, 3/3/2024, 2/19/2024, 2/25/2024) to the correct format date field that reflects all the dates in the string field? Please note that the string field me...

  • 92 Views
  • 3 replies
  • 0 kudos

How to search for what's missing?

Hi all, I'm working on a donor management system for a non-profit org.  Donors make pledges to give $x on x recurring basis, usually something like $50 a month.I've got a table for Donors, one for pledges, and one for donations.I need to have a way t...

  • 106 Views
  • 4 replies
  • 0 kudos

Split text to multiple columns

I want to separate the following text in different columns :Column A : @Ben//test-bug//Feb 22, 2024 3:54pm UTC//Budget//Test again//Test again//ModerateColumn B : @BenColumn C : test-bugColumn D : Feb 22, 2024 3:54pm UTCColumn E : BudgetColumn F : Te...

  • 89 Views
  • 1 replies
  • 0 kudos

Stop the countdown when status change to sent" or "refund"

Hi!I have a countdown for our warranty cases, which needs to be completed in the 45 days or less. Our customer fills out the Form, and the countdown stars when the Form is submitted. So the first field is "Form date" DATETIME_FORMAT(CREATED_TIME(), '...

  • 81 Views
  • 1 replies
  • 0 kudos

Separating string of text based on commas

I have a string of text in one column that i'd like to separate into individual columns. For example: Row 1: K, 1st, 2nd, 3rd, 4th, 5th, 6thRow 2: preschool (ages 4+), K, 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8thRow 3: ages 3+, preschool (ages 4+), K, 1...

  • 70 Views
  • 1 replies
  • 0 kudos

Resolved! Airtable formula error in 'search records' module in Make.com

Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))('Ind Doc' is an attachment field)Any help would be ...

  • 69 Views
  • 2 replies
  • 0 kudos
hauwi by 6 - Interface Innovator
Solved

SUMIF function

Hi everyone, I'm trying to implement the following Excel SUMIF Formula: SUMIF('Tabella raggr'!B:B;T2;'Tabella raggr'!D:D) Basically I have to add up all the values in column D where the corresponding value in column B matches the value in T2.In the s...

  • 292 Views
  • 1 replies
  • 0 kudos

Assign a Month & Year based on if a date falls in period.

Hello All,I wish to create an if formula which will return a Month Year result based on if a date falls on or between two dates.For example, if date A is on or between date X and date Y then return Month YearThink along the lines of budgeting and exp...

  • 76 Views
  • 2 replies
  • 0 kudos

Resolved! IF Formula Causing Trouble with Blank and Zero Amounts

I'm trying to build an IF Formula that seems like it would be straight-forwarded, but is proving to be more complicated than I thought it would be and has got me stumped. Both fields are Lookup fields getting a Rollup value from another table. I star...

  • 161 Views
  • 8 replies
  • 0 kudos

Add condition to formula to use column IF not Empty

Hello! I want to add something to the formula below. I want to add the condition that IF the column 'Fixed exchange rate' is not empty (there is a number filled in) THAN that number should be used BEFORE using the Forecasted exchange rate. IF the Col...

  • 81 Views
  • 1 replies
  • 0 kudos

Reproduce a INDEX-MATCH Excel formula

Hi everyone, I'm trying to reproduce the following Excel formulas in Airtable, which returns the third column from the "Tabella gest" table if the match is satisfied. INDEX('Tabella gest'!$B:$D;MATCH(1;('Tabella gest'!$B:$B=G2)*('Tabella gest'!$C:$C=...

  • 127 Views
  • 6 replies
  • 0 kudos

Resolved! Template help

Hello everyon, so I have created this project management based on the template. I have got around 10 people in the group and how can I do that when each person logs into that base it will show tasks by name individually? Cuz for now you have to do it...

Screenshot 2024-02-21 at 16.26.43.png
  • 1189 Views
  • 7 replies
  • 0 kudos

Resolved! Convert numbers to pre-defined letters - to create a simple password

Hi. I have a very basic password system that uses letters to denote numbers. The numbers come from a client's DOB.I have a date (DOB) field and another field using DATETIME_FORMAT to only show the numbers (DDMMYY). That's all fine.I would like to hav...

  • 229 Views
  • 2 replies
  • 0 kudos
hauwi by 6 - Interface Innovator
Solved

How to combine two fields in pair but separate lines?

My airtable has two fields, for example, 1st field name is "Test" and 2nd field name is "Solution". Records from both fields are come from Lookup of other fields so multiple records appear in "Test" and "Solution". i.e. one record of 'Test' contains ...

  • 95 Views
  • 1 replies
  • 0 kudos