I wanted the Weeknum of an end date field. The week number of those records that have 12/31/2021 is 1 instead of the last number of the year. How can I turn that into 52. I was trying to do a formula like this IF({End Date} = ‘12/31/2021’, “52” , WEE...

I am using my base to manage inspections. I would like to create an automation that if a record was modified after my last inspection than I get an email sent etc. Both dates are part of one table. I am trying to use a condition if the record is on o...