Stumped and Looking for Help

Matthew Bertucci

Help! I can't get this formula to work correctly. It works fine when the helper column is "1" but when its "0" it gives me a blank cell in the "Project Timing Status"cell. It should read "Pushed".

What am I doing wrong??

Thanks in advance for any advice you can provide.

Paul Newcome

You don't tell the formula what to do in the even that it is not 1. You have

=IF(Helper@row = 1, ........................))))))))

You need

=IF(Helper@row = 1, ........................))))))), "Pushed")

Note the number of closed parenthesis there at the end. You are basically adding that last "comma text string" portion right before the very last closing parenthesis.

Matthew Bertucci

Ahh, yes I see know what I'm doing wrong! Thank you, this helped me get it working. Much appreciated Paul!!

Paul Newcome

Happy to help. 👍️