rrenee · Renée Roberge · ✭✭✭✭

Overview

Overview

Roles	Member
Badges	10

About Me

About Me

Country	United States
Title	Renée Roberge
Industry	TechnologyGovernment
Area of Expertise	Core / Formulas
About Me	I like problem solving ^-^
How I Use Smartsheet	Automation and Optimization

Analytics

36

Posts

115

Visits

404

Points

Jul 24, 2024

Join Date

Jan 7, 2025

Last Active

Reactions

• Insightful 1

  1
• Vote Up 3

  3
• Awesome 4

  4

• Activity
• Discussions
• Comments36

• Re: Search a string and return multiple results

  rrenee

  12/24/24
  Hi there, I believe you could return each IF(CONTAINS()) statement by itself, and add the results together like so: =IF(CONTAINS("A-1", [Issue]@row), "Found A1","") + CH…
  2 ·

• Re: Calculating SUM of Duration

  rrenee

  11/11/24
  Hi! First, I would make sure the "Total Trip Duration" column is also a duration column, and use this formula to reference Sheet A: =SUMIFS({Duration}, {Assigned To}, ATS@row) This will fin…
  1 ·

• Re: Formula error Unparseable

  rrenee

  10/14/24
  Hi, I think this may work for you: =SUMIF( {Active New}, "ACTIVE New", {Active 1st QTR 2024} ) =SUMIF( criterion_range , criterion , range_to_sum ) The format is switched around, but you ca…
  2 ·