Hi, I’ve created a formula where the total billed column is calculated via the monthly billed and the start and end dates. However, I would like the total billed to be the same as the monthly billed if the end date is left blank. I cannot seem to get the AI prompt to work no matter how I reword it. Any suggestions?
This is my current formula:
IF({End Date} = “”, {Monthly Billed}, TEXT(ROUNDUP((YEAR({End Date}) - YEAR({Start Date})) * 12 + MONTH({End Date}) - MONTH({Start Date}) + IF(DAY({End Date}) > DAY({Start Date}), 1, 0), 0) * {Monthly Billed}, “$#,##0.00”))
And a screenshot of the current board where the formula is used:
