I have a table where I am tracking employee trainings. I have this formula to output whether the staff member is up to date on a certain training:
IF({Days} = BLANK(), “Overdue”,
IF({Days} > {Max # of Days (from Training)}, “Overdue”, “Up to Date”))
...
Hello!
I am working on writing a formula, and running into a few issues.
To preface, I am tracking employee trainings in this database. We have 3 trainings that expire. 2 expire after 2 years and 1 after 4 years. I am trying to write an if/then state...
I guess instead of override, I wanted it to be another possibility. So the first function would have “Overdue”, “Up to date”, and “Soon to be overdue” as possible values. I couldn’t figure out how to have a third option (confused by Airtable syntax),...
Hi thanks for responding and my apologies for the delay in response. I was on vacation. Unfortunately that doesn’t work with my use case. I’m attaching images to show what those columns actually look like.
The first image shows the training name, and...
You are right. That column was redundant so I removed it and fixed my days function. I’m still learning my way around Airtable, so my error there.
The max # of days lookup field idea was beyond helpful. Thank you so much for everything!
So the way we have our tables set up is different. I have the date of training as a column, a column to transform it into datetime format (which I will later hide), the days function (calculates the # of days from the date of training to today using...
Thank you for your help. I have played around with what you provided, and it’s not working. Every field is being calculated as “Up to Date”, even when it is over the time limit.
I tried playing around with the layout using some examples from the Airt...
