I'm using a simple formula to calculate the due date difference between today and the project due date:WORKDAY_DIFF(TODAY(), {Due Date})-1Which works for anything due today and in the future, but does not calculate properly for past due things. If to...
I have a multipart task that I think can surely be accomplished with a few formulas. I looked around the forums for a while and I think I have an idea but I haven't been able to put it all together yet! Basically I have lookup field collating all the...
Hello! I'm sure there is a very easy solution for this but I am having trouble figuring it out! I have an "Ad Record" field that may or may not have a date at the start (ex. "1/2/23 | Company | Product"). This formula parses out the date for me easil...
Hello!I have a large amount of sales records that I need to automatically transfer from an "Ad Chart" tab to another "Production" tab, to be assigned to various designers. I want to be able to check first if a record already exists on the Production ...
I want to parse text date entries from a single record into calendar date entries so that a calendar view can be used to visualize the dates.
We have our sales records entered by product, so each individual product gets a separate entry, with multipl...
Hi Arthur,Thanks for the reply! Our system is set up where the initial dates are records on a separate Calendar table so thats where I was getting the string of dates from, but they do eventually get translated into date field entries on another tabl...
Hi Adam, That's what I set up initially in the testing phase and it does work:However, it doesn't work at scale, there are simply too many records for it to check. From what I read, Airtable limits the Find Records action to 100 records and I need it...
Hi Adam, Thanks for the feedback!Without going into the data, we have a couple dozen products, for 100+ companies, across 3 publications on this "Ad Chart" table, so it makes sense for us to keep that as the central calendar and funnel projects out ...
Hi Jody, Thank you for the suggestion. I've looked into those and they do look useful in removing duplicates after they occur. However I'm hoping to have something that will check before a duplicate is made. That way I can set up my automation to run...
