Melissa Yamada · Data Analyst · ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	22

About Me

About Me

Title	Data Analyst
About Me	helping businesses leverage the power of data to make informed decisions and drive growth
How I Use Smartsheet	Managing Projects, Workflow Automations, Data Visualizations
Linkedin	https://www.linkedin.com/in/melissa-yamada/

Analytics

195

Posts

259

Visits

846

Points

Jun 5, 2023

Join Date

Mar 8, 2025

Last Active

Reactions

• Promote 1

  1
• Insightful 4

  4
• Vote Up 8

  8
• Awesome 35

  35

• Activity
• Discussions3
• Comments192

• Re: Nested IF with IF(OR statement not working

  Melissa Yamada

  12/02/24
  @JAAS What happened is your first IF statement should be an individual IF statement without the OR since they have individual logic when the statement is true and we'll need to adjust the number of c…
  1 ·

• Re: How to display a list of cell values in a report based on certain criteria

  Melissa Yamada

  11/23/24
  Hello @Kpyto71 , I'd be happy to help! Create a row report. Select both sheets (Sheet 1 and Sheet 2) as your "Source Sheets" Select only necessary columns to show (For example: Name of the …
  1 ·

• Re: How Do I Illustrate Checklist Data in a Dashboard?

  Melissa Yamada

  11/23/24
  Hi @megtro610 , I'd be happy to help! First, create a Metric Sheet (new sheet) and use cross sheet formulas to count for: Implemented and Evidence Attached Formula: =COUNTIFS({Is it implemented?}, 1,…
  2 ·

• Re: October Question of the Month 💭 Join the conversation and receive a badge

  Melissa Yamada

  10/14/23
  Bungee jumping in the Corinth Canal in Greece!
  1 ·

• Re: August Question of the Month 💭 Join the conversation and receive a badge!

  Melissa Yamada

  08/24/23
  The Smartsheet Community or @Darren Mullen the Smartsheet Guru!
  1 ·

Previous Next