L_123 Community Champion

Overview

Overview

Roles	Member
Badges	38

About Me

About Me

Not much happening here, yet.

Analytics

1,711

Posts

1,747

Visits

12.0k

Points

Jun 15, 2017

Join Date

Jul 26, 2024

Last Active

Reactions

• Promote 5

  5
• Insightful 63

  63
• Vote Up 155

  155
• Awesome 46

  46

• Activity
• Discussions89
• Comments1.6K

• Quick way to copy formulas across sheets I found

  L_123

  01/13/20
  Problem: I had the need to copy a list of 26 formulas to 56 sheets maintaining the formulas for each sheet. to increase the data collection across the sheets. All sheets have the same column names. S…
  20 ·

• Re: Odd way to emulate excel formula counta()

  L_123

  01/19/23
  hi @Genevieve P. Yes, this counts all cells, including blanks
  1 ·

• Re: Sum of Column with Multiple Criteria

  L_123

  11/08/22
  =SUMIFS({# of Lives},{Partner},"Bob",{Date},DATE(2022, 11, 1))
  1 ·

• Re: Multiple IF Statements

  L_123

  10/27/22
  =if(or(Status@row = "Complete",Status@row = "Abandoned", Status@row = "Reassigned"),1,0)
  1 ·

• Re: If statement that takes a column value and if meets a criteria, subtracts a number

  L_123

  09/07/22
  =IF([Apply TCC]@row=1,[Quote before TCC]@row-200,[Quote before TCC]@row) *Lol i had this window open in a different tab since this morning, didn't have that paul already helped sorry
  1 ·

Previous Next