I have a base with records that consist of the URLs of several images inside my site's midia folder. They look something like:https://mysite.com/news/april/banner1.pnghttps://mysite.com/news/may/banner2.pnghttps://mysite.com/news/april/etc/week2/file...
I'm struggling to figure out a good way to determine if a projects start and end date span any part of a specific year where start and end dates could span multiple years.So for example, I have records with the following columns for projects:Project ...
Okay i have a table that has input information that i have added formula to and get the desired results fields out of itresult fields are:Drawer Height, Side length, FB length, inner length, bottom width.note that each one of these fields has a value...
Good day all. I am trying to create a formula to name my Clients based on the following: If {company} is not blank, use {company} and if {company} is blank use {last name}, {first name} - and if there is a spouse name use {last name}, {first name} & ...
Hi friends! I am hoping this is easy, but I'm noob enough to not even know how to search up an answer in support/forums.My specific use is retreat registration. I have one table for Retreat Participants and a second for the possible Retreat Rooms.The...
Hello airtable community, I have this following formula but dateadd does not display the operation in the result thank you for your feedbackFranck IF({Date début package} != '', {Date début package},IF({Date début expl 23} != '', {Date début expl 23...
I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula ...
I am trying to have a due date automatically calculated, but don't want weekends or holidays included. I am using the WORKDAY function, but still getting weekends. Workback from is the date to begin working on each task and Workback is the number of ...
Dear community of people so much smarter than me!I am using Airtable to build a film budget that has a number of fields and formulas that are causing me headaches. Table 1) Budget top sheet (two rollup fields: budget & actuals)Table 2) Budget (above ...
Hi - I am trying to update a forecast in case the field hasn't been updated for over a month. The idea is that if there are no updates, the forecast would lower by 10%. It all looks great, until I have to "Update record", I pull the record ID (dynami...
