Best Of
Control Center Error message
Hi
I am new to Control Center and I'm trying to do a global update to a formula. Here is the formula I want to change
Current Formula:
=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = MONTH(TODAY())), 1)
New Formula:
=IF(AND(YEAR(Date@row) = YEAR(TODAY()), MONTH(Date@row) = MONTH(TODAY())), 1)
Changing Created@row to Date@row. When I test my update I am receiving the following error message:
I'm not sure what I am doing wrong. The Date column is checked as 'Restrict to Date Only'.
Thank you in advance for any assistance
Carol-Anne
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