Way to divide the values of two custom columns? | Community
Skip to main content
Level 2
October 16, 2020
Solved

Way to divide the values of two custom columns?

  • October 16, 2020
  • 1 reply
  • 820 views

I have two calculated custom columns driven by WEEKDAYDIFF expressions and I'd like to divide one by the other:

  • one column tells me the number of business days left until the Planned Completion Date
  • one column tells me the number of days difference between the Planned Completion Date and the Estimated Completion Date

For each task, I want another column to divide the value in the second column by the value in the first.

Is that possible? Please help!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ManuelBa

You probably have to merge the two calculations in one big set of formula. Direct access to another column doesn't work as far as I know...

1 reply

ManuelBaAccepted solution
Level 4
October 16, 2020

You probably have to merge the two calculations in one big set of formula. Direct access to another column doesn't work as far as I know...

JenDe1Author
Level 2
October 16, 2020

Thank you @Manuel Bause‚ ! I ended up adding everything into one column and it does work. Thanks for pushing me in that direction!