Empty Date Column Error

Platform discussions Special workflows & use cases
,
1

Hello Community,

I just need some help with this formula column its to calculate age in months from the approximate date issued of a device.

This it the Formula now:

IF({Approximate Date Issued} = “”, “”, ROUND(DAYS(TODAY(), {Approximate Date Issued}) / 30, 1, “”))

I would appreciate it!

2

Hi Diego,

Try:

IF({Date}="","",ROUND(DAYS(TODAY(),IF({Date}="",TODAY(),{Date}))/30,1))

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.

3

Doesn’t look like it liked that… now its just errors across the column, even when it was giving the correct {Age} output with the ones with dates and errors that just had no date in the {Approximate Date Issued} Column…

IF(
	{Approximate Date Issued} = "",
    "",
    ROUND(DAYS(TODAY(),
    IF(
    	{Approximate Date Issued} = "",
        {Approximate Date Issued})) / 30, 1))

This version of the Formula was working, the only errors it gave out was when there was nothing inside of {Approximate Date Issued}, being a date column that was empty, and it wouldn’t return the 0 or even if I want Text to populate within the column.

IF(
	{Approximate Date Issued} = "",
	0, 
    ROUND(DAYS(TODAY(), {Approximate Date Issued}) / 30, 1)
)
4

It does work. Look:

UntitledProject

IF({Approximate Date Issued}="","",ROUND(DAYS(TODAY(),IF({Approximate Date Issued}="",TODAY(),{Approximate Date Issued}))/30,1))

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.