Invalid parameter when using formula with empty field

Platform discussions Special workflows & use cases
,
1

Hi everyone,

I’m trying to create a formula in Monday.com that calculates the number of days remaining from a 90-day period based on the “Start Date” column. However, I’m encountering an “Invalid parameter” error when the “Start Date” is empty. Here is the formula I’m currently using:

ROUND(90 - DAYS(TODAY(), {Start Date}), 0)

How can I modify this formula so that it doesn’t return an error when the “Start Date” is empty?

Thank you for your help!

3

Hi Marcus,

Try:

ROUND(90-DAYS(TODAY(),IF({Start Date},{Start Date},ADD_DAYS(TODAY(),-90))),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.

1 Like
4

This worked perectly, thanks