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
-
-
Hello @Leibel Shuchat. Thank you for the response. I tried entering this formula. It's no longer giving me an error message, but it's not populating anything in the Truck Fee column.
I have another formula in the Total Labor column already, would that create any problems with this formula?
Do you have any other ideas?
Help Article Resources
Categories
Check out the Formula Handbook template!