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
JCorrell
(Jim - The Monday Man)
December 6, 2021, 6:19pm
2
@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
JCorrell
(Jim - The Monday Man)
December 8, 2021, 3:15pm
3
@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 “<>”.
1 Like
shunkins
(Seth Hunkins)
July 19, 2023, 5:54pm
4
<> 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.
JCorrell
(Jim - The Monday Man)
July 19, 2023, 7:29pm
5
@shunkins
LOL, Thanks for the input. But, you might want to test your theory.
shunkins
(Seth Hunkins)
July 20, 2023, 3:03am
6
@JCorrell I have several times, that’s why I commented. See for yourself below,
JI-LCI
(JI-LCI)
August 4, 2023, 9:05am
7
Getting same error, when using the “<>” in connection with IF statements.
JCorrell
(Jim - The Monday Man)
August 4, 2023, 11:41am
8
@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
JB007
(JulesWarner)
August 7, 2023, 12:29am
9
Good call Jim - so essentially, the same as Excel
HehkCon
(Harry)
August 30, 2023, 1:44am
10
Monday doesn’t seem to support the <> operator but a workaround that worked for me.
IF(({Value}= “”)=FALSE, VALUE_IF_TRUE, VALUE_IF_FALSE