For the Smartsheet community online: I've made a valuable discovery regarding Index(Match()) Cross Sheet References and all others when using Control Center in Smartsheet. If you're experiencing issues where these references don't work when creating "Children" from a "Parent" folder, here's a solution to save you time and…
Hi all I just wanted to pass along a pro-tip that I got from the Technical Engineering group at ENGAGE 23. If you need to deal with paged data in Bridge, it's not immediately obvious how to do that. At least not to me :-) So I asked. For example, if you do a List Sheets in Bridge, you may get some of the data back on page…
This little formula is useful for a range of solutions, like working out if a date is in daylight savings time or not. The examples below reference a date field named [Date]. The first part of the formula finds the date of the seventh day of the month. This is done so that the number of days from Sunday can be subtracted:…
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…
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…
what function return month name from date "i.e =TEXT(MONTH(TODAY()),"MMM")"?
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…
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.
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...…
I'm was using Generate Form to create a PDF I needed. While I was getting the content I needed, the font size in the form was wonky and inconsistent. The first 3 fields were in LARGE FONT size while the rest were a standardized. I don't know why or how the this happened. I was able to find a solution after an hour + of…
Issue: Have you ever filled out a form and noticed that the submissions aren't showing up in the sheet where they should? This is a common problem, but there's a simple solution! Cause: This usually happens because rows with previous data in your sheet were cleared using the "backspace" key instead of using the "delete"…
When designing Smartsheet dashboards, accessibility should be a top priority. This is when Smartsheet Dashboard Color Themes come to action! No more picking random colors or spending painstaking amounts of time making sure the colors you want to use actually work together. Now you can access 9 different color themes…
I've seen a lot of posts with people trying to figure out how to parse out predecessors so that they can set the status of the next task to "Ready" or something similar. I came up with a solution that worked for me, I figured I'd share it. This solution takes care of the various dependency types and lead/lags. 1) Create an…
