Best Of
Re: January Question of the Month - Join the conversation and receive a badge
I want to have dinner at one of those Michelin star restaurants where they experiment with food and food presentations.
Michael Drayton
Re: January Question of the Month - Join the conversation and receive a badge
Top of my bucket list is a visit to New York in December. My wife has a big birthday coming up soon so we plan on going there to celebrate.
John_Foster
Re: January Question of the Month - Join the conversation and receive a badge
Travel to Ireland and work remotely for a few months next summer.
Jayson Tyler
Now you can reorder items in your collection!
Hi Community,
Great news all, you can now reorder items in your collections for even easier management! Workspace administrators like you can organize your collections simply by dragging items up or down to better match the needs of your teams.
We will continue to make improvements to all things important to organizing and sharing work in Smartsheet. Stay tuned for some more exciting enhancements to this area coming soon! For more information, please read this.
You can also stay informed by Subscribe to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Thanks,
John Hieger
Product Marketing
John Hieger
Re: Formula not working on new sheet but same data
Never mind - I saw a similar post - you (Paul Newcome) had answered that question as well. I came up with
=IFERROR(INDEX({PERFECTION YARD CHECK TAG}, MATCH(VIN@row, {PERFECTION YARD CHECK VIN}, 0)), "")
and it works perfectly !
Davisc8
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