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
  • Link Local Files

    I believe due to the length of this conversation, the amount of recent submissions, and the amount of time it has been since a smartsheet rep has responded to this it needs to be brought up again htt…
    ·
  • 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 …
    ·
  • Re: Combining IF(AND and IF(OR statements

    =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19", [Preferred Date*]1 = "11/30/19", [Preferred Date*]1 =…
    ·
  • Re: Extract the first word from a cell

    You can use the one I gave you earlier, just switch the 10 to a 9 =LEFT([Column Test]@row, FIND(" ", substitute([Column Test]@row,CHAR(9)," ")) - 1
    ·
  • Re: Extract the first word from a cell

    ok... i'm at a loss. maybe the others can help you, but i haven't been able to find a good solution. Until then, here is a rather stupid workaround. in an empty cell post something like "A A&quo…
    ·
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