Calculating percent of a percent in an =IF(AND formula
Best Answer

I imagine you are getting an error? If so, it is most likely because of your "/ 1" portion. Try it without...
=IF(AND([Percent Complete]@row < [Timeline Progress]@row, [Percent Complete]@row = [Timeline Progress]@row * 0.3), "At Risk", "No Value")
Answers

I imagine you are getting an error? If so, it is most likely because of your "/ 1" portion. Try it without...
=IF(AND([Percent Complete]@row < [Timeline Progress]@row, [Percent Complete]@row = [Timeline Progress]@row * 0.3), "At Risk", "No Value")

@Paul Newcome Thank you!
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!