Hello, I'm trying to write an IF statement, but I can't seem to figure it out.

Here's what I'm trying to do:

I have a column (Truck Fee) that needs to equal another column (Total Labor) IF column Labor Type = On-Site.

I've read multiple posts that are similar to my situation and some that aren't and still can't seem to get it right.

I've been using (formula being put in "truck fee" column): =IF([Labor Type@row="ON-SITE" then [Total Labor@row])

What am I missing? Any help would be appreciated.

Thank you,

Josh

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!