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

Formulas Activity

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...

  • 12 Views
  • 0 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=...

  • 33 Views
  • 4 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
  • 42 Views
  • 5 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...

  • 195 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 ...

  • 58 Views
  • 1 replies
  • 0 kudos

Multiple IF statements

I'm trying to create the following automated options in a project management base:2+ days remaining1 day remainingdue today!1 day overdue2+ days overdueThis is my attempt, but I'm struggling to work out how to write the multiple IF statements require...

  • 98 Views
  • 7 replies
  • 0 kudos
Tt by 4 - Data Explorer

switch formula error

I have a project stage field that I need to convert into generalized phases. I have the below SWITCH formula and I cannot get it to save. All of the articles I have read have examples formatted this way - What is the issue? SWITCH(  {Project Stage}, ...

  • 70 Views
  • 2 replies
  • 0 kudos

Resolved! Line breaks and commas within quotes

I have a large multi-select that I then need to turn into a list format. I did the usual substitute the comma for a line break but unfortunately the items in this multi-select (that I can not edit) also use commas so now it's adding commas where I do...

example1.jpg
  • 70 Views
  • 2 replies
  • 0 kudos

Birthday Formula & Automation

Hello! I have checked out the the community for an solution to my problem and can't find what I am looking for to help me with my formula and automation. I am trying to set-up an automatic alert announcing someone's birthday on the day of their birth...

  • 65 Views
  • 2 replies
  • 0 kudos
LenaG by 5 - Automation Enthusiast

Resolved! Counting task completion

Hi all!I've been scratching my head and couldn't solve the problem quickly, so I'm asking for your help.I need to display a progress bar with the percentage of completion of a specific task, under which there are subtasks. In order to understand the ...

  • 60 Views
  • 1 replies
  • 0 kudos

The private share link you tried to reach is not available.

I'm trying to follow this guide, but everytime I reach the "Concatenate step" the link that shows up to me says "The private share link you tried to reach is not available.".That's a copy of the table I'm using to, why it doesn't works and how to fix...

  • 73 Views
  • 1 replies
  • 0 kudos

Filter rollup field by created date

I have rollup field that sum all the records from a table. I want to limit the sum from all to sum for current month only.How can I do it? 

  • 71 Views
  • 1 replies
  • 0 kudos

Resolved! If this or this then this otherwise that unless blank then stay blank

Hi there, I am trying to create an If/or formula and got it to work but I can't get the formula to be blank if there's no data in a field. I'm sure that makes no sense. Here's an example: Let's say I have a small list of produce in a column. I want t...

  • 90 Views
  • 3 replies
  • 0 kudos

Resolved! Replacing last 4 characters with stars ***

Looking for a solution for a public view where I would like to share information partly. To be exact - I'd like to hide the last characters of the text string by replacing the last letters with stars ***Tried to look up for ready solutions but had no...

  • 224 Views
  • 2 replies
  • 0 kudos

Resolved! Merging records with multiple parameters (script)

Hello, I'm trying to merge records in my table when 3 criteria match. I've been able to identify which records are duplicates, but I am having trouble merging them. Logically I believe my code should do what I want it do, I am not super familiar with...

  • 105 Views
  • 3 replies
  • 0 kudos

Adding sums between 2 dates

I need to be able to total up sums per line from an original start date for a full year after.Example:  Original  start date                   Amount paid-1, amount paid-2, amount paid-3, etc.                  This would be calculated for 1 year, the...

  • 285 Views
  • 4 replies
  • 0 kudos

Formula with empty value in field

Hi, Could you please help me with a formula I have 3 values: Estimated start dateEstimated end dateEffective end dateToday's dateI want to display "in progress", if I have no value in my effective end date cell and if today is inferior than estimated...

  • 127 Views
  • 6 replies
  • 0 kudos

Identify duplicates from lookup array

Is it possible to identify if there are any duplicates in a lookup array? I have 3 tables, all linked together: Entities (companies)MeetingsMonthsEvery Meeting is linked to a month (for various uses) and to an Entity. From the Entities table, I have ...

auekk2787_0-1708035991657.png
  • 116 Views
  • 4 replies
  • 0 kudos

Date Ranges

Hello!I am looking for a formula that will update on a month basis to pull data for a meeting.I have a few dates I want to pull from - Target Start, Target Completion Date, and Dev start. I would like to label any records that have a date in the upco...

  • 103 Views
  • 3 replies
  • 0 kudos
KGB by 4 - Data Explorer

Resolved! Counting Data based on Parameters

I have two tables: "Billing" and "Activities". I'm trying to find a way to combine this data so that I can see $ received from bills while only including "TimeEntry's". In this specific scenario, the amount I would need to see is $530, since the $100...

Screenshot 2024-02-15 102610.png Screenshot 2024-02-15 102556.png
  • 91 Views
  • 1 replies
  • 0 kudos