Garry McEwen · Sr Business Analyst · ✭✭

Overview

Overview

Roles	Member
Badges	3

About Me

About Me

Country	United Kingdom
Title	Sr Business Analyst
Industry	Live Entertainment, Travel and Hospitality

Analytics

7

Posts

39

Visits

35

Points

Dec 13, 2023

Join Date

Nov 6, 2024

Last Active

Reactions

No reactions yet.

• Discussions3
• Comments4

Discussions

• Please could someone kindly help fix IF/INDEX/MATCH formula

  Hello I need a little help if possible Original Formula: =INDEX({Jira MMP's Validation Results - Jira Status}, MATCH([Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0)) Which worked perfectly …

  

  Answered

  Formulas

  IF(

  Formulas and Functions

  42

  Sep 17, 2024

  3

• Please could someone kindly help me with this INDEX/MATCH/IF /AND Formula

  Hello There Smartsheet Community Please could you kindly point me in the right direction with my formula? Sheet 1 Contains the following sheet references "Status" = Jira Status "MMP" = MMP I need to u…

  

  Answered

  Formulas

  help

  IF(AND

  Formulas and Functions

  62

  Sep 10, 2024

  2

• Struggling to String together the correct COUNTIFS

  Hello There Community I need help with stringing variables together I am using the following formula: =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, (CONTAINS ("AA", (OR ("ALL"))))) Everything…

  

  Answered

  Formulas

  Formulas and Functions

  151

  Dec 13, 2023

  3