Formula Help - Blank Causing Error: #value

Platform discussions Special workflows & use cases
1

Hello,

So, I need some help with this formula.

I have a Time Column - Actual Effort
I have a Number Column - Planned Effort
Formula Column with CONCATENATE(ROUNDUP(DIVIDE({Act. Effort#Hours},{Plan. Effort}/100),0),“%”)

2024-03-25_20-03-31

I need it so that IF either column or both Planned Effort or Actual Effort nothing in them, then Formula column is blank.

I had another column with this type of issue and I managed to fix it, but this one is being evil.

2

Hi STX,

Try:

IF({Act. Effort#Hours}=0,"",CONCATENATE(ROUNDUP(DIVIDE({Act. Effort#Hours},{Plan. Effort}/100),0),"%"))

 

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.

3

It worked, thank you! It looks I was missing the 0 in my IF statements.