flag if > 6000
Options

Samuel Dowdy Jr.
ββββββ
=IF([Current Mileage]@row - [Service Mileage / Hrs]@row, >6000, 1)
What am I doing wrong? Iwant to flag if the difference is greater than 6,000
Best Answer
-
Hi @Samuel Dowdy Jr ,
Try this:
=IF(([Current Mileage]@row - [Service Mileage / Hrs]@row) >6000, 1,0)
The syntax for an IF statement is: IF(Β logical_expression,Β value_if_true, Β [Β value_if_falseΒ ])
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Samuel Dowdy Jr ,
Try this:
=IF(([Current Mileage]@row - [Service Mileage / Hrs]@row) >6000, 1,0)
The syntax for an IF statement is: IF(Β logical_expression,Β value_if_true, Β [Β value_if_falseΒ ])
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!