-
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 …6 · -
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…20 · -
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…5 · -
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…7 · -
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…6 ·