Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

IF formula not working

This seems to be a really basic formula I'm working on, but the result is only returning red for some reason. Can someone explain why other results might not be returning?

=IF([% Complete]@row < 70, "Red", IF([% Complete]@row = 100, "Green", "Yellow"))

Answers

Trending in Smartsheet Basics