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…
Hi,
This is perfect :grinning_face_with_smiling_eyes:
One final Q - I will be looking to break this down into monthly periods. Is this something I can tackle within Airtable too?
Jason…
AlliAlosa:
SUM(values)/{Total Jobs}
Hi,
Thanks for this.
I have implemeted and all the functions work correctly, however, the percentages dont seem to add up correctly?
Agree with this.
Being able to trigger the page designer would be great.
Something like this should be achievable from Zapier as per the new record in view options.
Jason
Hi,
Just installed this today.
It pulled the data for the first time and since has show the following error.
Script Error - No item with the given ID or you dont have permission.
Jason…
