#Invalid Operation - Referencing another sheet

Andrew Sorg

I am having trouble with this error. Pulling data from a sheet with same column names.

(dumbing my equation down for simplicity)

{Master Daily Job Log Range 1} = Date Column in Master sheet.

{Master Daily Job Log Range 2} = Job Overview Column in Master sheet.

Equation in my Yesterday's Job Report Sheet

=IF({Master Daily Job Log Range 1} = Date@row, {Master Daily Job Log Range 2}, "")

Find more posts tagged with

Formulas

Accepted answers

All comments

Andrew Sorg

SOLVED. I figured out my error, shouldn't have been using an IF statement. Used VLOOKUP and pointed to separate sheets and not my master summary sheet.

Genevieve P.

Thanks for posting your solution!

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.