Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Dec 29, 2021 06:06 AM
Hello, I’m Phil
And I’m working for a video production company.
We create video for others companies, all the production follow up is made with airtable.
I’m working on a formula that can increment a cell (0,1,2,3)
if specific date cells are filled
let’s illustrate my use case
I need to log the delivery date of video production (SLA are calculated using those dates)
Tell me what’s your advices :slightly_smiling_face:
thanks
Dec 29, 2021 08:20 AM
Hi @Phil_Ravier
This can all be done in a single formula, unless you have some other compelling reason to keep them separate.
IF({v3}, 3, IF({v2}, 2, IF({v1}, 1, 0))) * {unit_cost}
By ordering the conditions in reverse like this, you ensure that the highest possible multiplier is applied.