Calculating a value only if the start date of a timeline is in the past

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?

@ccronkhite,

I would need more detail to give you the math portion. But for the if portion, try this:

IF(Days({Timeline#Start},TODAY())<0,"Math","")

Replace “Math” with your desired calculation.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.