-
Smartsheet to Excel via Power Query
Hello, I have ran into an issue where parts numbers get recognized as null by Power Query if the column type is text. When exporting the Smartsheet there are no issues what so ever but depending on the length and contents of the part number it will get dropped. Please refer to the below image.
-
Unparseable for multiple IF statements
Hi, I'm trying to use multiple IF formulas within one cell by transferring from the Excel sheet I created it in, but I keep receiving the "#UNPARSEABLE" error code. Here is the formula I've attempted in SS: =IF([Support Intensity]@row="high", 9),IF([Support Intensity]@row="medium", 6),IF([Support Intensity]@row="low", 3)
-
Increase in cell limits?
I attended this year's Smartsheet Engage and there was a big announcement that Smartsheet would be increasing cell maximums in sheets at the end of the year. Any more word on that? What is the new max cell limit?
-
COUNTIF where counting if cell contains "Super" but "Superstar"
I have a formula where I'm counting how many products are at a certain status and where they have a title of Super, Super & more or Super & Design (B&W) - but want to make it scalable. Is there a way to create a formula where I can tell it to count any cell where "Super" is the prefix? And secondarily, not count anything…
-
Workflow enhancement - copy a column/cell to another column/cell
A workflow enhancement that is similar to the Change Cell Value. However, instead of changing a cell, copy it to another cell. Use case: I have a formula that calculates a date. However, I want to keep the initial value of the date and therefore, don't want to reference the date formula because it will change. A workflow…
-
Dynamic View Comments notifications for user without access to source sheet
Unfortunately, because Dynamic view does not support @mention for users not shared with the source sheet, this means that my 700+ users have to revert to email. Is there a timeline for this feature to be added? Thanks
-
Extra days being added to task dates.
While creating a project timeline I've just noticed that some dates are populating with extra days. For example, I have a task with a 5 day duration with a start date of Monday 07/29/24. I would expect this task to end on Friday 08/02/24 however, the end date is defaulting to Monday 08/05/24. I am also seeing some tasks…
-
Freeze Row
Enhancement request to add capability to freeze row (like freeze column)
-
Welcome to Just for fun - let's post some memes!
Hey everyone, welcome to the Just for Fun Topic (formerly known as a Category) which is just that - a place for all of us to take a breather and have a laugh or two. To start, let's go with the Internet's chosen love language: Memes. What's your favorite Smartsheet meme? Drop it in the comments (keep it clean please!).…
-
Community Corner Newsletter [April 2024]
Hey hey everyone, Rebeca here. I’m back to introduce April’s newsletter, and I’ve got a lot to share with you, including new topics, badges and a giveaway. But first things first, big shout out to @Genevieve P. for the great March issue. She really inspired me to explore my country even more with the eyes of a tourist!…