Nested IF Statement

Steve DeLuca

I'm fairly new to Smartsheet and  I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue...

=IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe Lincoln", [Planned Hr]@row * 200), and so on...))

I have a team of 8 in which 5 have different bill rates, so I would need to repeat this string to include all of them in the formula.

Thanks for the help

Andrée Starå

Hi Steve,

Welcome to the Community and the wonderful world of Smartsheet!

You were very close and were closing each IF (with the parenthesis).

Try something like this.

=IF([Assigned To]@row = "Bob Dole"; [Planned Hr]@row * 175; IF([Assigned To]@row = "Abe Lincoln"; [Planned Hr]@row * 200))

The same version but with the below changes for your and others convenience.

=IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175, IF([Assigned To]@row = "Abe Lincoln", [Planned Hr]@row * 200))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD