HELP!! I just can't get the following to work into one formula.... basically I have four sets of dates that I need to set status' for to trigger email reminders (1st Pupdate, 2nd Pupdate, 3rd Pupdate, 4th Pupdate). I need a single formula that joins...
Hi Everyone,I am sure this is a common question, but I can't seem to find it... When staff join they have a 3 month/6month and 9 month review. They then have their Annual review (which is always 1 year after their 3 month review). They then have a mi...
Hi everyone!Okay.. so... bear with me... I have people that have multiple roles {Contact Type} in the company (Humans Table)I also have a Junction table (CT Category by Human) so I can manipulate the dataso in my third table (CT status NEW) now that ...
Help! We are a Charity that trains Assistance Dogs for Autistic Families. I have a table with ALL the people that have ever had to do with thecontact/dealings with charity at some point... however, this is my dilemma:Mr X is currently a 'Volunteer' a...
I have a Purchase Order table and an Expenses table that when records are created and automation pulls the records into the Budgets MASTER LIST using roll up and look up fields. Each Budget is allocated to a department (Autism Liaison, Events, IT & C...
For those that need something similar... this formula works nicely: Thanks to everyone's input - it all helped IF({1st Pupdate}, IF(IS_AFTER(TODAY(), {1st Pupdate}), "✅ ", IF(IS_SAME(TODAY(), {1st Pupdate}), "", IF(IS_AFTER(TODAY(), DATEADD({1st P...
Thanks for this @Alexey_Gusev but when I put the formula in which includes all the other pupdates every entry has the 1st update reference in it! it doesn't seem to go past the first IF!! (I have even done the entries backwards as suggested above!)
Oh wow @Alexey_Gusev , thank you for that, I just needed someone to provide me with the foundations to start me in the right direction so I could then build on that formula to create the below which works perfectly! Thank you so much for your help:) ...
I managed to find a Solution!!: 1.There are no changes to any of the fields or tables in the base mentioned in the original message.2. Automation is as follows:
