Hi there!
I’m trying to figure out the correct syntax for a formula in a board.
In the board, we have a timeline column where we track the start and end dates of a project. In another column, we have the total value of the project. I figured that part out: {Project Value}/(DAYS({Timeline#End},{Timeline#Start})/30.42)
However, I want to calculate monthly revenue for each project, but only if the project has already started–that is, if the timeline start day is either today or in the past. How do I use an IF statement and the timeline variable to do that?