I am trying to create formulas that skips weekends, showing 5 days after a date field called Sendt (and then two other formula fields for 14 days later and 30 days later)I tried using the workday function, however it is displaying a Sunday, as you ca...
Hello everyone,We have a team of 10 persons that have a non-linear schedule (i.e., We are working between 1 and 5 days a week and those days varies from one week to the other).We have defined a set a todos (4tasks) for each day. Every week (Sunday) w...
I am trying to create a payment due date based on adding days (either 15 or 30) depending on what kind of vendor type is selected. Both 'if' parts of the formula work if I place them in separate formula fields but I would like this to all come throug...
Why is array unique formula considering a single data twice? I have typed multiple topics and when I use the formula I can see topics repeated. Is there anyways to avoid repetitions?
Hi Airtable Wizards, I have the following formula which is formatted in currency and occasionally returns a -$0.00 result, where to my untrained eye, I cannot see why. {PM: TOTAL BANK ALL EFTPOS}-{PM: TOTAL EFTPOS SALES}"PM: TOTAL BANK ALL EFTPOS" a...
Hi, I have many rows with multiple attachments. Some attachment urls are having https://v5.airtableusercontent.com/v1/ format. Some of them have https://dl.airtable format.How do i tweak the script if possible to get https://dl.airtable format? I nee...
Hi all,For about a month, I have noted that when I create a new table and the Primary field , which I have as a formula set to pull it from from the "Name" field, doesn't automatically self populate. So if i create 1-2-3-4-5 new tables, with individu...
Hello! I'm creating an Airtable form, and I want to enable a default text to fill in a field if the field is left empty by whoever is filling the form. Example if name is not filled in, then it will default to anonymous instead of being blank. How do...
Hello All,I am trying to figure out how to perform a calculation if possible.I have jobs that are sorted by date. Currently, data is grouped by date. I want to take the flat rate for example $500 and divide that by the number of jobs. So that I can h...
If you look at my attached images below, I'm struggling with the CONCATENATE function. I want to add the COMPANY as a prefix to each of the multiple items listed in the PRODUCTS column, but concatenate only adds it as prefix to the first item.I am d...
How can i create a field that reads, for example, "Friday March 17, 2023" ?
Hi, I'm trying to create a formula that will direct to a Gantt view filtered by a ProjectID field (So I can create a "Open Gantt Chart" button in an Interface using the "go to url in record" action that will open a Gantt view filtered by a specific p...
I'm trying to build a formula that returns "true" every 180 days (and subsequent 180 days) after a record was created. I'm heading down a very complicated route involving dividing {Days Since Created}/180 and checking the length of the return resul...
HII have "Creation Time" column for my records. The records are created when user submits the form.Everyday at 9 am or 10 am in morning meeting, i need to show all records created between " Yesterday 8am to Today 7:59am".Is there a formula to achi...
I imported a financial report from PayPal. All of the Negative amounts in the "Amount" field use a "-" in front of the value. I want to create a new field that removes the "-" and just lists the value of the Amount field. If the amount doesn't have ...
Hello everyone, I'd like to make a formula with an IF statement that shows "OK" if a date is in the last 6 complete months. For example, if today is the 17th of March, it would show "OK" for every record since the 1st of September.Is this something p...
I am trying to figure our how to use rollups. Let's assume I have a list of applicants and associated interviews. The interview has "interviewer name" field.Soapplicant1 -> (interview1; interview2)Interivew1: JohnInterview2: RebeccaI am creating a ro...
In the theatre world our "fiscal years" are actually seasons that start in the fall and end in the spring. And specifically, there are two big "quarters" = a fall/spring season, and a summer season. More complex than just "quarter 1" plus "year." an...
Hi! I need help creating a formula and not sure if it is possible. I have a table that has several tasks with a single select option of completed, missing, or n/a. I want to get the average score of the tasks that are marked as completed. Example: Ta...
Hey everyone! I need help making a formula that gives me the date of the next coming Wednesday based on another date in a date field. So for example if the date field shows 3/4/23, I want the formula to return 5/4/23. Thanks in advance!
| User | Count |
|---|---|
| 769 | |
| 721 | |
| 578 | |
| 461 | |
| 269 |
