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…
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
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")"?
Hello everyone! I am excited to be speaking at the "Leveraging the Query String in Forms" session at Engage 23! I wanted to share a formula that a customer and I developed to replace any special characters that could show up in cell when you are building a URL to a form with query string parameters using a formula. This…
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…
Greetings all, Because I grew tired of spending an inordinate amount of time piecing together URL query strings, I've compiled all of the UTF-8 character codes (that I came across) into an easy to use reference sheet. I've also added in a column for the corresponding CHAR() function codes and conditionally formatted the…
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 have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
Here's how I figured out HH:mm. I welcome all simplification suggestions. The combined formula in A38 is this monstrosity (but it works): =IFERROR(IF(INT(SUMIFS({Duration}, {CURWK}, 1, {Event Type}, A$37) / 60) < 10, "0" + INT(SUMIFS({Duration}, {CURWK}, 1, {Event Type}, A$37) / 60), INT(SUMIFS({Duration}, {CURWK}, 1,…
This one comes up a lot, so I thought I would provide a few ways to solve it. The question is this: can I use the OR function in the CONTAINS function? For instances, you want to see if a cell contains "apple", "banana", or "orange". In short, you can't use OR in the CONTAINS function (TLDR: because OR provides binary…