IF::Then reference separate sheet

Hello

I have (2) sheets I am working on. One is my Main_Running project sheet.

The 2nd, I would like to populate depending on whether a column in the Main is "starred"

If Column_is_starred; then I want it to pull in information from a separate Main_sheet column.

I would like the 2nd sheet to only be populated if/when the Main_sheet has a starred value.

eg if there are 100-rows in Main_sheet, but only 25-starred; then Sheet_2 should only have 25-rows populated.. (not wanting null or n/a returns.

This is what I have; understanding the return of "0" is not ideal, and likely errors elsewhere along the way..

=IF(({[Running Project Revamp 24] Range 1} = 1), {[Running Project Revamp 24] Range 2}, 0)

Thoughts?! Thank you.

Find more posts tagged with

Cell Reference Limits

IF(

Accepted answers

All comments

Brian Wilson DC

@ssHelpMe Hello! Is the data that you are pulling onto the second sheet, where you'd have 25 entries going to change? If not, then you could just use an automation on your primary sheet. Just set it up so when a main entry is starred it copies the row to the second sheet.

ssHelpMe

Hello Brian

The data on the 2nd sheet will be changing and will be new/changing content

I basically only want to reference 1 or 2 columns from the Main_sheet. A Project_Name column, and possibly a Project_Number column. Not bring in the entire row.

The remainder of the the 2nd_Sheet will be built out independently. It will be a schedule of sorts, containing different information including Manufacturer_Name, Model_Number, Size/Connections, etc, etc.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.