L_123

L_123

L_123 Community Champion

Overview

Overview
Roles
Member
Badges38

About Me

About Me
Not much happening here, yet.

Analytics

1,711
1,747
12.0k
  • Query Strings - Development

    So I've developed several processes that fully rely on query strings for a variety of reasons, and many of my users find it difficult to reverse engineer my sheets to develop similar solutions, even …
    ·
  • Quick way to copy formulas across sheets I found

    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…
    ·
  • Re: TRIMMEAN in Smartsheet

    I would use standard deviations from the mean. You can use a z table to lookup the z score correlating to the desired percent, and replace both of the 2's in the formula below. You can also change th…
    ·
  • List of date formula I have used repeatedly

    Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most…
    ·
  • Re: Rounding up a formula return

    =ROUNDDOWN((MONTH([Year-1/Deliverable-1 Invoice Date]@row) - 1) / 3) + 1 Give that a try. Your quarters don't start at the beginning of the year either with your solution. I don't know if that was on…
    ·
Default Avatar

Badges

  • Community 10th Anniversary
  • Seventh Anniversary
  • $1B in annualized recurring revenue
  • Early Adopters Program
  • Operate at Peak Human Nominator
  • Question of the Month: July Participant
  • 25 Awesomes
  • Sixth Anniversary
  • Community Champions
  • 2023 Core Product Certified
  • 2022 Core Product Certified
  • 100 Up Votes
  • 5 Awesomes
  • Fifth Anniversary
  • 2021 Top Contributor
  • Fourth Anniversary
  • 2020 Product Certified
  • 100 Answers
  • 25 Insightfuls
  • 25 Up Votes