5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Sep 19, 2018
‎Nov 29, 2022

User Statistics

  • 8 Posts
  • 0 Solutions
  • 0 Kudos given
  • 3 Kudos received

User Activity

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…