IF Formula questions

Options

Apologies in advance, this is a real newbie questions.

I am trying to create an IF formula which checks if the value of column Chargeable is TRUE it should then divide the value in Quantity cell by 7 and store in the formula cell. If Chargeable != true then set the value in the formula cell to zero. Following is what I have tried which gives me #UNPARSEABLE error.

=IF(Chargeable@row="TRUE"), ((Quantity@row/7), 0)

Thanks in advance for nay help available.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!