-
Create dynamic custom schedules based on selections in intake
Hi all, I recently developed a cool solution to an issue that we had... how to build a custom schedule based on selections in an intake form. This solution leverages Bridge, but you could do the same thing using a third party integration tool. THE GOAL The process goal for this solution is: Collect project requests using…
-
SOLUTION: DAY and DATEONLY functions ignoring locale information
Users have been running into problems with the DAY function returning the wrong day and DATEONLY returning the wrong date. The reason is that these functions do not reference the user's locale information, and resolve against UTC time instead. That's fine if you live in the same timezone as Britain, but a tragedy if you…
-
Month Name written as Text for Today's Date
what function return month name from date "i.e =TEXT(MONTH(TODAY()),"MMM")"?
-
Date Formats in Worksheet
Just for knowledge - Someone had raised this question about date formats in the community and I wanted to add the response to it so it might help some others as well. A mini disclaimer here that most of you might already know this but sometimes we all forget the most obvious things that are in front of our eyes so just…
-
@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...…
-
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…
