Hi I got help with this a little while ago and it was perfect but now I want to add to it and anything I try does not work.This is relating to an commissions payable per situation.IF( {Booked By} = 2, {Points Paid} * 0.04)The above works however I ...
I am trying to create a formula with this information: If a person who booked the reservation was 2 then it should apply the formula if it was anyone other number then the field should be blank or 0.- I have created a field for booked by and put numb...
Hi using this formula works…
IF({Type of Task}=“CANCEL”,DATEADD({Check In Date},-1,“days”), IF({Type of Task}=“REBOOK”,DATEADD({Check In Date},-60,"days”)))
But then I want to add another condition so have copied it the exact same way and it doesn’t ...
Hi, I am new to airtable, I’m creating a zapier automation from airtable to google sheets transferring data from a view (which is locked so no changes can be unwittingly made), when I test within Zapier the record fills into google sheets correctly b...
So now I am going wild and want to elaborate on this, I have added more possibilities to -IF(
{Booked By} = 2,
{Points Paid} * 0.04
)I want to put a few soIF booked by 2 points paid is 0.04 ORIF booked by 1 points paid is 0.03 ORIF booked by 0 ...
