Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 20, 2022 01:47 AM
Hai, can anyone help me to write formula but based on single select column. If single select = Kg will be multiply 1 ( * 1) then If single select = Box will be multiply 5 (* 5) and then if single select = 200 gram will be divide 5 (/ 5)
Solved! Go to Solution.
Jan 20, 2022 09:13 AM
Hi Lucas. You want to use the SWITCH statement. Something like that below should work.
IF(AND({Jumlah (Kg)},Unit), SWITCH(Unit, "Kg", {Jumlah (Kg)}, "Box", {Jumlah (Kg)} * 5, "200grm", {Jumlah (Kg)} / 5 ) )
See Solution in Thread