-
@row referencing cell above
Is there a way that I can use @row to reference the cell above? I'm creating a formula to check for duplicates and I want to compare details in the current row to the one above.
-
Bulk delete sheet rows using Windows Powershell
There is not currently a method for bulk deleting rows using the Smartsheet API (that I could find) so thought I would share what I came up with. Deleting single rows or small chunks of rows for sheets with thousands of rows is slow. I was able to use the example found here as inspiration...…
-
Getting list of archived projects from Resource Management
Here is how you can currently get a list of archived projects from Resource Management. This solution does not explore Bridge or integrations using API. Resource Management does not allow you to export the archive status or archive date of a project This should be fixed. This could be possible this is possible through…
-
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…
-
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…
-
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?
