hi everyone,
i am trying to create a formula that will allow me to use a colum as enterable if a certin condition is met and calculated from a formula if the condition is not met.
currently i am using this in order to calculate the pricing to a client
Pricing =
{EffortPlanned NIS}*{% Price Ratio}
do anyone know how to make the formula. if {% Price Ratio} is empty {Pricing} is enterable and {% Price Ratio} will be calculated {EffortPlanned NIS}{Pricing} else Pricing =
{EffortPlanned NIS}{% Price Ratio}.
whatever colum is filled first the other one will be calculated.
From the screen grab if the %price value and entered value are empty it will state to complete the Enterable valule field
If %price ratio & Effort Planned are populated it will calc the Effort Planned x %Price Ratio
If Effort Planned & Enterable Value have data it will cal Effort Planned x Enterable data
Hope this provides what you need, let me know if you need anything in addition, don’t forget to mark as a solution, if it’s what you need
Many tahnks in advance
Danstrong text