Formula with a range

Carrie Young

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!

Ayelet Weiner

If your Complete column is blank you can use this formula. This way you don't need to have a range.

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))

Let me know if that works for you!

Carrie Young

Thank you so much!

Ayelet Weiner

If your Complete column is blank you can use this formula. This way you don't need to have a range.

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))

Let me know if that works for you!

Carrie Young

Thank you so much!

Ayelet Weiner

https://community.smartsheet.com/discussion/comment/276891#Comment_276891

You're very welcome!🙂