# IF Formula

Options

Hi everyone,

I'm having trouble with the IF formula:

what I want to to be able to classify a task depending on the amount of hours that we need to develop it.

so I have this chart:

1 - 500 hours = 1

500 - 1000 hours = 2

1000 - 1500 hours = 3

1500 - 2000 hours = 4

more than 2000 hours = 5

=IF([Total Hrs]@row < 500, 1, [Total Hrs]@row < 1000, 2, [Total Hrs]@row < 1500, 3, [Total Hrs]@row < 2000, 4, [Total Hrs]@row > 2000, 5)

• ✭✭✭✭✭✭
Options

You're close! Try this:

=IF([Total Hrs]@row < 500, 1, IF([Total Hrs]@row < 1000, 2, IF([Total Hrs]@row < 1500, 3, IF([Total Hrs]@row < 2000, 4, IF([Total Hrs]@row > 2000, 5, "")))))

Let me know if it works!

Best,

Heather

• ✭✭✭✭✭✭
Options

You're close! Try this:

=IF([Total Hrs]@row < 500, 1, IF([Total Hrs]@row < 1000, 2, IF([Total Hrs]@row < 1500, 3, IF([Total Hrs]@row < 2000, 4, IF([Total Hrs]@row > 2000, 5, "")))))

Let me know if it works!

Best,

Heather

• Options

It worked!!! thank you so much :) you're the best!🤩

• ✭✭✭✭✭✭
Options

@Ana Hernandez Happy to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!