I’m trying to add two columns together, a width and a height column, which will then mark a Formula column as “YES” if the sum of those columns exceeds 100. I need an additional “Total” column, which happens to be set to “$” to then increase it’s number value. help?
Hi @HunterFitch
Try:
IF(SUM({Column1},{Column2})>100,"YES","NO")
As far as the “Total” column, I am not sure what you mean by “increase it’s number value”. If you wish to write the sum of the 2 columns, then:
SUM({Column1},{Column2})
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.
Hi @HunterFitch
If I understand you correctly you are looking to have a premium rate for and width and height over 100 combined.
Here is the solution you are looking for:
-
Determine if width + height exceeds 100. See images below. The gentleman who replied belore I did had the right idea for the start of the solution. His formula will output a yes or a now.
-
Total the work based on the W + H. What I’ve set in my columns is a regular rate you would run for a per unit of measurement ($5) and a premium of 5% for anything exceeding 100 units. The total column is a formula column that will adjust the output depending on if the sum of W + H is over 100 or not. Shown below.
If this was what you were looking for it would be really appreciated if you could mark this as the solution. If you need more help on it, tag me and I’ll be right on to help.