Best Of
Re: Can I start my project codes from zero for the 2025 year?
Try this (assuming [UniqueID] is an auto-number column with no formatting):
=LEFT(Department@row, 3) + "-" + YEAR([Project Intake Date]@row) + "-" + IF(YEAR([Project Intake Date]@row = 2024, 100 + COUNTIFS(UniqueID:UniqueID, @cell <= UniqueID@row, Department:Department, @cell = Department@row, [Project Intake Date]:[Project Intake Date], IFERROR(YEAR(@cell), 0) = 2024), RIGHT("000" + COUNTIFS(uniqueID:UniqueID, @cell <= UniqueID@row, Department:Department, @cell = Department@row, [Project Intake Date]:[Project Intake Date], IFERROR(YEAR(@cell), 0) = IFERROR(YEAR([Project Intake Date]@row), -1)), 3))
Paul Newcome
Re: Automated Workflows Limit
Hi Nasir,
I'm not aware of any limit for the number of Automations but there are limits for the number of notifications that are sent. (approx 30 automations is ok, I have a client that has almost 70 I think)
More info: https://www.smartsheet.com/legal/limits-policy
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Andrée Starå
Re: Using =Value to return a number but gettting error
You got me on the right track thinking of this as a negative number…I had in my head that the "-" was reading as text (which it probably is) but it also sees it as the negative number if the number is there too, I was just not seeing it in my head.
So, I shortened it up a bit, using the ABS function which will give me not only the number, but eliminate the leading zeros. So far I have not found a value in the data that breaks this. I can now use this in my Index(Match and it works out just right.
=ABS(VALUE(SUBSTITUTE(MID(Location@row, FIND("fz", Location@row) + 3, 10), " ", "")))
Matthew 5
Re: Is there a way to identify what Reports certain Columns are used in?
The only thing I can really see doing here is adding the "Sheet" reference column to see what sheet the column is coming from, so you can go rename that column. Then all reports that are connected to that column will update with the new column name.
However unfortunately there is currently not a way to identify what reports a sheet is connected to. That is a request in the community pages to have a tab on the side of a sheet that shows what reports the sheet is used in. As far as I know it is not voted up high enough yet to be part of the roadmap.
Automation email combined all emails to the same client.
Good afternoon Sir/Madam,
I found out the issue why my clients are not getting my automation emails. I have enabled custom domain and the problem is as follow and I'm wondering if there is a fix for it:
- There is a list of 150 rows of data and some of these rows have the same contact (email). Once a field is trigger to send automation, it appears that the email was combined with ALL of the information within 1 email. This can make the email super long as our text is already enough for 1 email. I believe this is why my email never get to the client. Is there a way for these email to be separate from each other and not combined?
thank you.
Brock
Re: January Question of the Month - Join the conversation and receive a badge
My bucket list item is become Smartsheet Certified this year and read one book a month
ChrisJ2025
Re: Negative Number Formatting in Parenthesis
This would go in a helper column for display only. It outputs a text string, so if you have to run calcs on the numbers, you'll want to reference the original column. This also only works as long as your number is less than 1 trillion. There may be a more efficient formula that can be written, but I had to come up with this one in a hurry for a client. It works though, so I haven't spent any more time on it yet.
=IF([Total Column]@row < 0, "(", "") + "$" + 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)) + IF([Total Column]@row < 0, ")", "")
Paul Newcome
Re: Dashboard View Restrictions
@Joe Mul You can accomplish this by using the Current User filter in the report builder.
Isis Taylor
Re: Can I use Summary fields in formula
Hello @SueinSpain - The formulas in your columns can reference any of your sheet summary fields. If you have a sheet summary field called "doors", then you would refer to it as doors#. If you have a summary field called "Fire Doors", then you would refer to it as [Fire Doors]#
The pound symbol is the key. Hope that helps! Also for reference: https://www.smartsheet.com/template-gallery/formula-handbook
Scott Peters