Best Of
Re: Bring Back the Outlook Add-In - Please upvote this!
This is necessary for my organization. Without this functionality, many of our processes are less efficient as our customers use email and Smartsheet in tandem. Bring it back, brin git back, bring it back….better.
cgam
Re: Is there a way to maintain currency formatting when within a formula?
I would suggest using helper columns as the formula to get a text string with the "$" and commas and whatnot out of a number is a bit lengthy.
But once you set up the helper columns for the amounts, you can reference the helper columns in a string formula the same way you did above.
The formula below will convert any positive number below 1 trillion into the needed format (I would suggest a find/replace to swap [Total Column]@row with whatever column name you are using in your sheet so that none get missed):
="$" + IF(LEN(INT(ABS([Total Column]@row))) <= 3, RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 6, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 9, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 8, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 12, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 11, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 9)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 8, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3))))) + IF([Total Column]@row - INT([Total Column]@row) = 0, ".00", RIGHT([Total Column]@row - INT([Total Column]@row), 3))
Paul Newcome
Re: Automation triggered when rows are changed is happening on initial input
The solution suggested on 6/2 is not applicable, because we cannot apply the “any value” option when we put any where clause if we want to add it to the condition.
So the problem is still there. Also, it makes no sense that this is an expected behavior.
anil ayhan
Re: Automation triggered when rows are changed is happening on initial input
I have reopened my ticket with smartsheet for further explanation (I was out of office and wasn't able to implement the proposed solution). I did try to change the trigger on the add to not match the trigger on the change, and I am still getting both notifications. Stay tuned….
linda.hathaway
Re: Automation triggered when rows are changed is happening on initial input
Thanks for reopening the ticket! I'm having the same issue and am hoping they'll fix it on their side - will be watching for updates. I agree that this is something that changed on the Smartsheet side and it doesn't make sense for that to be expected functionality because why would there be a "when rows are added or changed" option if changed always means added.
krush
Re: Saving a "Form" for later use without submitting as of yet
Forms are sometimes lengthy and people need to collect information to complete them. Currently they have to submit mid-way and we need to set up update requests or share the underlying sheet in order for them to update/complete the form. Dynamic Views are great as a workaround but require a bit more training to use for most that are not in SS everyday. It would be ideal if there was a save function for users to save work and come back to complete then submit. We would love this update and it would save our teams a lot of time!
BTaylor2
Re: June Question of the Month - Join the conversation and receive a badge
One of the best examples of a community I've been part of is the one in my town—Kindred, North Dakota. It’s a small farming community of about 1,000 residents, and what really makes it special is how tightly knit we are. Everyone knows each other, and we celebrate everything. Whether it’s a big game, a town event, or just a beautiful day, the community shows up.
Kindred is especially passionate about sports. It’s not unusual to see the whole town rally behind a team. After championship wins, it’s common to welcome the athletes back with a parade of rescue vehicles—lights, sirens, and all—escorting them into town. That kind of pride and support really sets Kindred apart.
People here are incredibly involved. Volunteers are always stepping up, no matter the event. When I first moved here, my son and I went for a walk and ended up at the Kindred Ambulance building. I had done my EMT training there a few years prior, so I was familiar with the staff. They told us about a night parade happening that evening—and it was absolutely amazing.
The parade was full of life and participation, not just from Kindred but from surrounding communities as well. (Our school district includes five nearby towns.) Floats threw out light-up maracas, sunglasses, necklaces, and candy, while kids lined the streets with flashlights, hunting for every treat. Fargo Life Flight even made a special appearance, flying over town in their helicopter!
That night was such a vivid example of what makes Kindred feel like home—welcoming, proud, generous, and full of heart.
Go Vikings!
mcullen
Re: New streamlined creation experience
Hi all - echoing what others have stated. Really struggling with the inability to move "sheets" to old folders. I have over 200 sheets that are in the main directory that I cannot move. I have sheets that are tied to other sheets in an existing folder that I can't add in. We really need the functionality to create folders (outside of workspaces) and to be able to move sheets freely.
JohnSpirawk
Re: Dashboards in Copied Folder Losing Report/Data Source References
@Sachin Kumbar
From what we could figure out, it wasn't a change that caused the widget ownership issue. It apparently has been this way a long time.
I'm sure one of the Smartsheet employees can shed some light on this for us. Maybe @Jim Hinkey can help us out
Have you seen the updated API documentation post? https://community.smartsheet.com/discussion/137201/smartsheet-api-docs-site-is-getting-a-major-upgrade
MarceHolzhauzen
Re: Workflow - SAME SHEET copy a cell to another column
Many times I would like to be able to essentially copy a cell. For example, we get a date the customer requests for delivery - I would like to copy this to a cell called "original delivery date" so we can change the requested date if needed but still hold the original request.
Bob Kahn