Formula with a range

Options

Hi,

Calling on all formula guru's. I can get my formula to work for the absolute parts but when it comes to a range I get the #unparseable error. Below are the two formula's I've tried.


=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row > .01 and <.1, "In Progress")))

=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row = .01-.99, "In Progress")))

Thanks!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!