# Formula to return different values

Options

Hello,

I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas?

=IF(Dates@row <= \$Dates\$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), ""), IF(Dates@row > \$Dates\$2, SUM([Estimated at Completion]10+[Planned Billable Labor]@row), "")

Thanks!

Carly

Tags:

• ✭✭✭✭✭✭
Options

Try this...

=IF(Dates@row <= \$Dates\$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), SUM([Estimated at Completion]10+[Planned Billable Labor]@row))

• ✭✭✭✭✭✭
Options

Try this...

=IF(Dates@row <= \$Dates\$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), SUM([Estimated at Completion]10+[Planned Billable Labor]@row))

• Options

Thanks, Paul! That worked!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!