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:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!