Skip to main content

I am trying to write a formula for my ‘Quantity Live’ column that says “If the subitem’s ‘Pub Status’ is not LIVE, put 0. If the subitem’s ‘Pub Status’ is LIVE, put the value from the ‘Quantity Using’ column.

 

Any help would be appreciated.

 

Thank you,

Linda

Hey @lindamarieberry , please check the following

and the formula is :

IF({PUB Status}="LIVE", {Quantity using}, 0)

Let me know if you have any other questions

Thanks 

Reply


Terms & ConditionsCookie settings
logo