INVALID OPERATION ERROR - HELP NEEDED

Thank you in advance for your help. I actually worked with Smaartsheet's AI Help to generate and work through the formula. I have checked it twice and still get the same error message. Here is the formula:

=IF(AND([Tester ID]@row = {DE2ET Tester ID}, [Scenario ID]@row = {DE2ET Scenario ID}, {DE2ETDefectProgressDefectRetest} = "Defect Retest"), "Defect Retest", "")

I have 2 sheet. Both have the same columns: Tester ID, Scenario ID and Defect Progress. If Tester ID and Scenario ID match and Defect Progress on the Defect Tracking sheet changes to Defect Retest, I want the Defect Progress on the Tester Scenario Sheet to be Defect Retest.

Any suggestions?

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

There are no accepted answers yet

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.