Hi guys,
I am currently trying to use the formula column to add 20KG to a number if a value is present.
“if({weight(unpacked)} is “something” then + 20KG”)
The formula column should output the SUM of weight(unpacked) + 20KG, for example if weight(unpacked) were 100KG the formula column should output 120KG.
And is there a way to have the KG after the value.
Cheers
Justin
Hi Jim,
It is a number column.
Cheerd
This should do it:
IF({weight(unpacked)} > 0, {weight(unpacked)} + 20)
The best way to set the units is to update the column summary:
Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)
Hi Jim,
The formula column is coming up with “true” if the number column is empty.
Also my number settings looks different to yours.
Would you have a solution for these issues.
in the meantime I have created a temporary solution using two formula columns and two numbers columns.
NUMBERS COLUMNS
“{WEIGHT(UNPACKED)}”
“{PALLET}” =20KG
FORMULA ONE
“({WEIGHT(PACKED)})”
IF(AND({WEIGHT (UNPACKED)}<1,{PALLET}>0),“”,“{FORMULA ACTION}KG”)
FORMULA TWO
“{FORMULA ACTION}”
SUM({WEIGHT (UNPACKED)}+{PALLET})
Is there a simpler way to do this?
Cheers.
Oops.
Just change formula 2 to this:
IF({weight(unpacked)} > 0, {weight(unpacked)} + 20, "")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
