-
Tips & Tricks for the new experience
Hi everyone, I hope you're well and safe! I thought it would be a good idea to start a thread with tips & tricks for the new experience. Here's my first one, and it's a big one, IMHO. Full-Screen View Have you found any? I hope that helps! Stay safe, and have a fantastic day! Best, Andrée Starå | Workflow Consultant / CEO…
-
Solution Showcase: Determining if a task can start based on predecessor status
I've seen more than one question in the community about determining if predecessor tasks are complete for the purpose of notifying the successor task owner that the task can be started. I wanted to create a demo to show that this can be done. It's a bit time intensive and requires quite a number of helper columns. Here's…
-
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…
-
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…