joshsorenson - profile

joshsorenson · Jan 06, 2024

Hey Sharon, Might try this:IF(FIND("ongoing", {Project Status}) > 0,"ongoing",IF(FIND("planned", {Project Status}) > 0,"planned",IF(AND(FIND("hold", {Project Status}) > 0,NOT(FIND("ongoing", {Project Status})),NOT(FIND("planned", {Project Status}))),...

joshsorenson · Jan 06, 2024

You make look at using something like fillout.com Instead, fillout can read from airtable as well as write to it. This might get you closer and even cut out make.com in the process.

joshsorenson · Jan 06, 2024

Not sure exactly what you are doing, but this should work.({Processos ambientais quantidade - Calibrado} * 0.4) + ({Processos Ambientais Valor - Calibrado} * 0.4) + ({Registro de ocorrências - calibrado} * 0.2)

joshsorenson · Jan 06, 2024

If I'm understanding correctly then this is what you want. IF(DATETIME_DIFF({End Date}, {Start Date}, 'days') = 0,1,DATETIME_DIFF({End Date}, {Start Date}, 'days'))

joshsorenson · Jan 06, 2024

The hard part of this is you would need to determine the hours in a day that are working hours too which the formulas aren't really meant to account for.

User Statistics

User Activity

Re: Conditional formula for multi-select cell

Re: Airtable relation & product

Re: How to put weight on each variable in the formulas

Re: Combining an IF formula with a DATETIME_DIFF formula

Re: How to Calculate the working days and return the value in terms of day and hours like "4.75