Adding Or to If Formula

Anthony Barthelemy

Smartsheet Community:

I am trying to add an OR to my existing formula:

If Status has Failed or Passed 100% other wise 0

=IF(Status@row = "Failed", 1, 0)

Thanks

Andrée Starå

Hi Ray,

Try something like this.

=IF(OR(Status@row = "Failed", Status@row = "Passed"), 1, 0)

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Anthony Barthelemy

Excellent, Worked! I am always a parenthesis or comma away from having the correct formula lol.

Can you take a look at my manual % Complete Formula? I need it instead of using the Automated Formula Provide by Smartsheet through the Project Settings. I just need a weighted average of all the children. I believe that is what the Project Settings in Smartsheet use

Existing Formula:

=SUM(CHILDREN()) / COUNT(CHILDREN())

My Formula % Calculation was 20% which is incorrect. It should Match the Smartsheet ( Automated Project Settings) Below.

Automated (Smartsheet Project Settings)

Summary Task % =30%

Task 1 20%

Task 2 40%

Task 3 60%

Thanks