Removing ! (One of the Parameters is Invalid) In Formula Column

Platform discussions
,
1

Screenshot 2025-07-30 at 1.45.24 PM

Hello, this is my formula and when one of the dates isn’t filled out it shows the ! (One of the Parameters is Invalid) In the formula Column. How can I get it to be blank instead?

2

@gracemeyer, here you go…

IF(AND({TOB Date}, {Planned Sunset Date}), 
   ROUND(YEARFRAC(
      IF({TOB Date}, {TOB Date}, "1900-01-01"), 
      IF({Planned Sunset Date}, {Planned Sunset Date}, "2100-01-01")
   ) * 12, 
   0), 
"")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday