I am a therapist who sees clients. Each client will be charged a fee in Great British Pounds (£). If attended, a client will be charged £50. If a client does not attend or provides a late cancellation, their fee will be £35. I have a Google Calendar synced table. I have added one tick box column titled ‘Did Not Attend?’.
I want a formula that records £50 if attended (default state) but changes the fee to £35 if I tick the box that denotes a did not attend/late cancellation status.
A little problem to be solved that I hope someone might enjoy.