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

• Re: List of date formula I have used repeatedly

  L_123

  08/26/21
  Returns the 3rd friday of the month specified by the date in column A. *can be used to return x weekday of any month by changing the 18 =DATE(YEAR(A@row), MONTH(A@row), 18 + IF(WEEKDAY(DATE(YEAR(A@ro…
  1 ·

• Re: TRIMMEAN in Smartsheet

  L_123

  08/10/21
  If you want a smartsheet based z table you can copy mine below: https://app.smartsheet.com/b/publish?EQBCT=d37bad54bb3045c2be5e9f0f78cc0db3
  2 ·

• Re: Friday to Friday pull

  L_123

  07/26/21
  @Dustin Whitehead Whoops. You're correct, I messed up my signs, my bad. =COUNTIFS({CPM On-Call Form Range 1}, [Primary Column]@row, {CPM On-Call Form Range 3}, and(@cell <= (today() - weekday(toda…
  1 ·

• Re: RAG status formula using TODAY and end date

  L_123

  08/10/20
  My bad I got a sign mixed up. =IF(Status@row = "Complete", "Gray", IF(Status@row = "Cancelled", "N/A", IF([End Date]@row >= TODAY(), "Green", IF([…
  1 ·

• Re: Can a sheet summary always reference the same cell when form entries are added?

  L_123

  02/08/21
  Yeah index( ,1) is amazing. if you have a moving target, you can use index( ,match()) in combination with a unique value in another row to return it as well.
  1 ·

Previous Next