Hello!Pulled up a list of three dates from a linked table. In this table, there is a separate date on each record. Looking for a way to find the latest of the three dates, that is not later than the separate date in the record. I can find the last...
I work in a digital archive and I'm using Concatenate to create a unique naming formula based on certain fields in a spreadsheet. However, some items have different naming requirements. What I would like to do is be able to tell this formula to skip ...
I'm having a rollup field which is giving me the latest logged date from another linked table. The rollupfield is used in formular fields where it needs to show the date inserted into some text, but no matter what I do it gives me an error when I use...
Hello amazing people! I am working on my film workspaces and trying to build a table to use for a Page Designer for a Call Sheet. I have several tabs I need to pull details from, all based on the Date Field. This Scenes tab is one of the places to pu...
I have a field called "Child_of" that links the child with the parent, both located on the same table.Since Airtable does not offer backlinking to the same table, I need a formula to know if the parent has a child. I do not need the backlink to be ad...
So in my data column A is a created time date, column B has many lots, and column C has a birth date corresponding to each lot, so if column B is: 'LotA, LotB, LotC' then column C is, let's say, would be '03/28, 03/29, 03/30'.How can I add another co...
Hi everyone,I have a scenario one Make, sending infos from piwaa (linkedin connected inbox) to my airtableFor the module Airtable search records, I have a formula to help finding the record concernedI want it to find the right record to update thanks...
Currently, when I click a link in an Airtable 'button', it opens that link in a new tab. I do not want to open the link in a new tab.I want to open the link in the same tab (which will navigate away from Airtable).Any idea on how to accomplish this?
Can someone help me modifying this formula so that if the condition 'Trækdato (FarPay)' field is empty, the formula field is left blank? Right now it returns an #ERROR! IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Trækdato (...
Hello,I have a table with fields like this : The "First char" field is a formula that return the first character UPPER of the "First name" field. Then, the field "check" is used to filter a view from A to E. So i need a formula that show "OK" if the...
Hi!So I'm trying to set up a table for our home school group to house everyone's birthdays. I've scoured the forums and can't work out why I'm getting an error on all dates on or after 13/05/2019. All dates prior to this work fine and I just can't fi...
I have tried multiple way, know I am missing something, but can't work out what. I have one column for Date and the next column is yes. Meaning that consent has been given and on the date in the column. I now need a formula field that will return the...
Hi all,Some context: I have multiple bases with a list of tags that can be associated with records in other tables through a linked record field. If the users cannot find the tag they need, they can enter it as a new tag, but due to view permissions,...
Doing some work for an ATM Placement Company.When a client signs on, we have a set # of ATMs that we promise to place for them after they set up their bank account.Currently we are looking for a way to update a dropdown status based on a few factors ...
I have a column named MIN and need to add leading zeros when the value in column is less than 4 numbers:BeforeAfter Formula220022456045610000100008888888888999999999999999999This is what I have right now but is giving me an error for the largest numb...
Hi there,I got trouble with using IF functions across Date field, currently I want my result is:IF({Date field 1} is filled, then "Completed"), IF({Date field 2} is filled, then "Extended"), IF ({Date filed 3} is filled, then "Waiting")How do I make ...
Sorry if this is a basic question— I am just starting out learning how to use formulas with little/no prior excel experience.I have a formula that calculates the difference between today's date and the date a video was released. I have it returning t...
Hello Airtable community!Hoping someone can assist with this formula conundrum. In short, seeking to calculate 'pending' (sold but not yet activated) subscriptions within an Airtable base. Subscriptions Table primary field is per nominated subscriber...
Hi, everyone! I need help in combining names from two Rollup fields with the result below:First Name Last name Formula Field (Result I want)Mary A. ...
I am trying to build a module in Make (Integromat) that will find a single Airtable record that matches an AND + OR condition:My formula is:AND( {NMI}="XXXXXXXXX", OR( {Subscription status}="Active", {Subscription status}="Pending", {Subscription sta...
| User | Count |
|---|---|
| 772 | |
| 725 | |
| 579 | |
| 461 | |
| 269 |
