You need to sign in to do that
Don't have an account?
Jordan Torrey 23
In my "IF" statement, I want my "false" value to do nothing in my formula.
Just getting more practice with formulas but have run into an obstacle. Hopefully I'm overthinking it, but I'm writing a throw away formula:
IF( AnnualRevenue >= 1000000, NumberOfEmployees, " ??? ")
The goal is to throw an error message telling the user if the "AnnualRevenue" is greater than or equal to one million, then the "NumberOfEmployees" field is mandatory, else do nothing. What value do I need to enter in the "false" field? I've tried using "null" however there needs to be an actual value. Is using an "IF" statement the wrong route to take for this goal?
Any assistance is more than welcome. Thanks in adnvacned!!
IF( AnnualRevenue >= 1000000, NumberOfEmployees, " ??? ")
The goal is to throw an error message telling the user if the "AnnualRevenue" is greater than or equal to one million, then the "NumberOfEmployees" field is mandatory, else do nothing. What value do I need to enter in the "false" field? I've tried using "null" however there needs to be an actual value. Is using an "IF" statement the wrong route to take for this goal?
Any assistance is more than welcome. Thanks in adnvacned!!
Are you writing a formula field? If you write a Validation rule, all you need is the the formula below, and add the message you want in the Error Message section. If the record meets the criteria below, it should throw the error that they need to fill out the NumberofEmployees field.
All Answers
Are you writing a formula field? If you write a Validation rule, all you need is the the formula below, and add the message you want in the Error Message section. If the record meets the criteria below, it should throw the error that they need to fill out the NumberofEmployees field.
Yes apologies; I missspoke. Thank you for providing this formula. One of my attempts was close to this but looked more like:
IF(ISBLANK(AnnualRevenue) >= 100000, NumberofEmployees, ???)
But for obvious reasons failed. Your formula worked like a charm. Thank you for your assistance Kim!
im trying to display custom comments for a feed object in my view... i only want the output text to display that comment body when the value evaluates to true....
also the code is iterating through a list of custom Comment Objects.... please any help would be appreciated..thanks