Forum Discussion

leinad13's avatar
leinad13
Advocate I
10 years ago
Solved

IF - Formula in Add Custom Column

I am attempting to add a simple column to show true or false if another column is greater than 2. I have written the formula as :   =IF([Spec]>2,true,false))   However, the edit window accepts it...
Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    10 years ago
    Excel=IF(test, value_if_true, value_if_false)
    Power Query=if test then value_if_true else value_if_false
itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
10 years ago
Excel=IF(test, value_if_true, value_if_false)
Power Query=if test then value_if_true else value_if_false
joeort's avatar
joeort
Advocate IV
10 years ago

If I wanted to compare a column against a hard coded date, how would I write that formula?

 

if date(2013,4,1)<[Date__c]then 1 else 0

Gives me an error that date isn't recognized.