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 basic of the formulas out of this. Below are just some of the ones that I thought of now, i'll comment more as I use them.…
Formula for Finding ISBN Numbers
I wanted to share a Formula / Method for validating ISBN numbers since I didn't see any discussions or suggestions on how to go about, I thought I would make a post here for if anybody wanted it or had discussion ideas on it. I was recently tasked with creating a book request form where users would need to submit ISBN…
Ranking without Duplicating Ranks
I used the RANKEQ function for the first time recently and realized that any identical values will have the same rank. It will skip however many duplicates you had in the ranking numbers, so you may have a ranking scheme that looks like 1, 2, 3, 3, 3, 6, 7, 7, 9, 9. This may be useful in some situations but it is actually…
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 with the official smartsheet help guide. I've made a fairly basic tutorial so I don't have to keep explaining it, and thought…
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. Smartsheet defaults to saving the end result, and doesn't offer the ability to just copy the formulas from one column in one…
Can you use 2 match criterias in an index/match formula?
I am looking to structure an index and match formula, but it needs to match two columns of data and having some troubles. Is this possible or will I need to create a work-around with a Join function in another column?
For Every one want to have More color symbol for health Status column.
Dear Community Memebers, I saw many equations asking to have More color symbol for health Status column, so i added this post to be a simple reference to solve this issue and with your help and comments we can develop it to match the most of your wishes. the following screenshot shows the color reference you can use it in…
Using Forms & Automation to Drive Leads
Good afternoon Smartsheet Community, We use Smartsheet Forms sometimes for some client contact forms to track real estate or other sales leads. We found it helps to use Forms and Automations to make it super easy to contact potential clients in a timely manner. I broke it down step by step with video walkthroughs below:…
Using a nested IF to determine a range
Here's a little tid-bit I just figured out today... You can use a nested IF statement to output ranges/cross sheet references that are to be evaluated. The particular use case that led to this was an INDEX/MATCH where we wanted to INDEX on a single date column, but MATCH on one of 4 different columns depending on an Asset…