Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote","On Hold - Do not Quote"))We are hop...
Hi everybody,if I can ask for help with formulas in IF statementsI have developed Glide app with Airtable, works really good.I have a table WorkOrders, and among other columns, I have:"Start time", "Start kilometers", "End Time", "End kilometers", "T...
How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful ...
Hi All I would like to know if someone can assist me with create the formula used in the time off id column for this video at the timestamp 2:04 https://www.youtube.com/watch?v=Q-MEmIHCHU4&t=8s
I have a simple task tracker with a single table containing a list of tasks. I have a self-linking field to allow for a single level of subtasks. I primarily use Interface lists to view tasks. However, I also assign tasks to be completed by varyin...
Okay guys, got a doozie... Basically, in the screenshot I have a table, which is the main table that 99% of things sprout off from. We have customers, who through a webflow form are able to select accessories to add on to their purchase. That gets re...
Hi! I am unsure if it is possible to create a formula to make this work for my school, please help!I have a base created to track all applicants. We offer 5 trade classes each held 3 times a year that have a minimum age requirement; age 16yrs and 8mt...
We have a database of transactions that is monthly via csv import. This contains information like transaction id, amount, duration.Most transactions are simple one-time occurrences; however, some transactions happen over the span of months.For these ...
This might not be possible (especially since our nonprofit is on a free plan) but we have a number of projects that require review by our general counsel before they can finish. We have a tab with the start and end dates of each project. Our General ...
I have a table linked to itselfA Lookup field type still works fineBut a Count field type always returns the value 1 when in some cases it should be more than 1
