Hi all, I am attempting to populate a due date for when corrections on a document are needed to be done by.A regulatory team reviews a submitted file. When it's determined that corrections are needed that team updates a single select field named "Fil...
Hi, I am trying to populate in a cell, "Urgent" when a project is coming up on its {Due Date} within 7 days of today AND the cell that has my completed date, {Date Filed} is Empty. If {Date Filed} is Not Empty, i'd like it to populate "Completed". If...
Hi Saravanan,Thanks for the response. It looks like im still getting the same error with the formula you provided. I decided to test if it has something to do with my "Holidays" list and removed it from the formula. It is now populating something oth...
That is super helpful Alexey. That worked and I appreciate the feedback as well while I get started with AirTable. I didnt think of it till just now, but would you be able to provide an edit to include something that will change the cell content to s...
Hi,Sorry for my ignorance. Could you show how that might look more drawn out? I was easily able to get the first formula indicating "Completed", but the 2 following I'm having issues writing out and not getting an error. Thanks!
