Best Of
Re: Group WorkSpaces and organize them in "folders"
Also came here to request the ability to group workspaces into folders - as admins we are members of too many and it makes finding what you need unnecessarily difficult.
Laurenzella
Re: Automate Sending Welcome Email to New Smartsheet Users in our Company?
Hi,
I hope you're well and safe!
I'm not sure if it's possible to send an email automatically, but as you probably know, you can create a custom welcome screen with the same information.
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏
Andrée Starå
Re: June Question of the Month - Join the conversation and receive a badge
I honestly cannot think of a better vision for a community than my employer. There are are almost 3000 of us (half in 3rd world countries) united under a single vision to release children from poverty. When contacting someone new, even on the other side of the world, you feel this instant connection and shared purpose. We all have this deep desire to serve over 2 Million kids and their families.
Matt_A
Re: Customize Account Invitation Email
I love this idea. We run into issues where its confusing for our end users and I personally walk through it with them. It also comes through as our director's email and name and not just generic company name and Smartsheet. This would also include the training materials I have for them based on how we utilize Smartsheet for them as well.
AngB789
Re: Send Dashboard via email - manually and automated workflow
I like that idea of automations from Dashboards.
AngB789
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