Formula Question

[art (Arthur)]

Hi, I would like to create a formula, I one drop down column that has 2 options:

1. 30 min
2. 60 min

I would like to create a formula to remove the " min" and have just the number.

Then, I would like to create a second formula to take the “30” or “60” to multiple by a number, let’s say $10.00, and get the total which would be either “$300.00” or $600.00".

Can anyone help me with this?

[themondaymaster]

@art

I would like to create a formula to remove the " min" and have just the number.

Then, I would like to create a second formula to take the “30” or “60” to multiple by a number, let’s say $10.00, and get the total which would be either “$300.00” or $600.00".

Hi @art this should work:

IF({Label} = “30 min”, 30 * 10, IF({Label} = “60 min”, 60 * 10, 0))

replace “Label” with the name of your dropdown column, and the 10 is the number you can change to mutlply 30 or 60 and then use the column summary to add the “$”

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi @art,

This will work as well:

 VALUE(LEFT({Label},2))*10

 

---

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

• Create formulas without using the Formula column (and avoid its limitations)
• Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
• In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

[art (Arthur)]

@themondaymaster

IF({Label} = “30 min”, 30 * 10, IF({Label} = “60 min”, 60 * 10, 0))

Worked like a charm! Thank you very much!