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
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!
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%
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
