Hello, I have a base where I need to produce a report/view each day between 05:00 - 05:00 rather than a midnight to midnight (yesterday) view. Each entry has a Opened Date field which includes the time in the field. Is there a formula which I can use...

Hello, I have a table where I track contractors for attendance within an SLA. I have SLA Due date and time and Site Attendance date & Time. I have then have a formula column which tells me if the job is pending, Missed or Met. What I now need is to c...

I have written the following formula to identify when a SLA is missed or MET based on the Date Completed and the SLA DUE Date. IF(IS_BEFORE({SLA Due},{Date Completed}),"SLA MISSED ",‘SLA MET’) This works but it shows ERROR when the Date completed is ...

Hello, I am looking to write a formula to populate a field based on two separate fields using the IF AND statement. This would be Field 1 = A and Field 2 = B then insert C into the formula field. Is this possible? Thank you. Jason…