Custome formula to check if Timeline column is blank

Looking for how to validate if a timeline field has had a value entered into it for use in a custom formula column.

I have tried taking the variables and doing something like this

{DatesScheduled#Start} != “”

But this is causing an error with the formula. have tried replacing the “” with blank, null, none, ‘’ etc and all the standard go to’s

Any pointers on what would be the statement, just needing to set a value when this column has not yet been entered

@Reddevildragg

“!=” is not a valid comparator in monday formulas. You can use the NOT() function like this

NOT({DatesScheduled#Start} = "")

Or just use the “false” portion of the IF function like this:

IF({DatesScheduled#Start} = "", "Empty", "Ok")

Jim - Subscribe to The Monday Man
Watch Our Latest Video: A Killer Combo: monday.com, Integromat & Google Sheets - Recurring Tasks Example

1 Like

@Reddevildragg

I don’t know where my brain was when I answered this…

Everything I wrote was technically correct. But… the correct “not equal” comparator operator in monday is “<>”. :grin:

1 Like

<> actually doesn’t work. the “<” is blue likes it’s working for the formula and the “>” is white and actually makes the formula a less than formula.

@shunkins

LOL, Thanks for the input. But, you might want to test your theory.

@JCorrell I have several times, that’s why I commented. See for yourself below,

image

image

Getting same error, when using the “<>” in connection with IF statements.

@JI-LCI

The “error” that you and Seth are referring to is only an error in how the comparison operator is being displayed. It does not change the function of the operation.


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

Good call Jim - so essentially, the same as Excel :slight_smile:

Monday doesn’t seem to support the <> operator but a workaround that worked for me.

IF(({Value}= “”)=FALSE, VALUE_IF_TRUE, VALUE_IF_FALSE