Multiple IF Statements

hello,

I have this formula that works great: =IF(Status@row = "Complete", 1). I change the "Status" to complete and the "Done" column box is checked.

However, when I change the Status to "Abandoned" or "Reassigned" I also want the "Done" column box checked "Complete."

How do I do multiple IF functions? The "Nesting IF Functions" help page was...well, no help.

Thanks!

Find more posts tagged with

Accepted answers

L_123

=if(or(Status@row = "Complete",Status@row = "Abandoned", Status@row = "Reassigned"),1,0)

All comments

L_123

=if(or(Status@row = "Complete",Status@row = "Abandoned", Status@row = "Reassigned"),1,0)

James.Johnson

perfect! thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

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.