Best Of
Re: Customize an auto number
Try this:
=[Auto Number]@row + "-" + [Business Unit]@row + "-" + RIGHT("0" + DAY([Submission Date]@row), 2) + RIGHT("0" + MONTH([Submission Date]@row), 2) + RIGHT(YEAR([Submission Date]@row), 2)
Paul Newcome
Re: Can't create dashboard chart with Report information
You can only chart numerical data. You will need to group the report and then use the Summarize function within the report to get your count / avg / etc. that you want charted.
Paul Newcome
Re: Automations: include attachments
It seems like the ability to add attachments to an automation would be a basic ask. It feels like it's been overcomplicated and should be an easy function. My vote is to add this functionality ASAP.
🚀 Let your creativity come alive at full speed!
After a long search I finally found the right model including Smartsheet Logo :)
https://www.linkedin.com/groups/14245563/
NicoLHC
Re: February Question of the Month - Join the conversation and receive a badge
Here are a few I think could be fun!
- “The Easter Egg Hunter” 🥚🔎 – Awarded to users who discover and share hidden or lesser-known Smartsheet features.
- “Smartsheet Mythbuster” 💡🛠️ – For those who clarify misconceptions, debunk myths, or provide expert-level troubleshooting.
- “The Lifesaver” 🆘🚑 – Given to users who provide a solution that drastically helps someone in a time-sensitive or high-stakes situation.
- “Reverse Engineer” 🔄📊 – For those who take complex challenges and break them down into simple, step-by-step Smartsheet solutions.
- “The MacGyver” 🛠️💡 – Awarded to users who come up with ingenious Smartsheet workarounds using unexpected features.
- “Smartsheet Historian” 📜🕰️ – A badge for long-time Community members who can recall and explain how Smartsheet has evolved over the years.
- “The Speed Solver” ⚡✅ – For those who consistently provide quick and accurate answers to Community questions.
Re: Maxif Next Date to Review
You would use a MAX(COLLECT()) Combo. So something like this:
=MAX(COLLECT([Date]:[Date],[Document Name]:[Document Name],@cell=[Document Name]@row))
Leibel S
Re: Reference row if its the newest entry
I was able to figure this out and instead of deleting my post, I wanted to share the solution so that it can be refined and reused by others.
In Sheet 2 I used this formula in each column (in this case it was for the Project Health column):
Where the first "{Weekly Statue Update Range…" is referencing all the columns in Sheet 1, the second points to the Report Week (Monday) column in Sheet 1, and the third highlights all of the headers in row 1 of Sheet 1.
Note: I did have to manually add Headers to Row 1 as a reference point. If these don't match up between sheets 1 and 2 you will have errors.
I'm sure this can be cleaned up a little, but I just wanted to share what I had in case it helps others.
Daniel Barber
Re: UPDATE: FOUND ISSUE - No changes to automation, but receiving some emails but not all
I am going to put your answer down here so you can considered this question answered and it will stop showing up in the unanswered questions:
Fix was to guarantee that all conditions were being met for the automation. Conditions could be "Yes", "No", and "Blank" and the automation did not have a pathway for "Blank."
UPDATE: FOUND ISSUE - No changes to automation, but receiving some emails but not all
UPDATE: We had two conditions, one that would send an email based upon a column being 'Yes' another that would send an email based upon the column being 'No' - however, I didn't account for the fact that we would sometimes skip over the question, so the column would be blank. I've updated the automation to include 'Blank' along with the 'No' response in the column.
We are running into a situation where the automation on a sheet hasn't changed at all, but the email that should be receiving the notification is receiving some emails, but not all emails. It should be triggering every time a new row is added and we know it works because they received an email this morning with a new row item, but it hasn't worked a few other times. Any ideas on why this might be happening? I hoped to find the automations in the audit log, but it sounds like the automations are not being recorded in the log.
Thank you in advance!
Oliver Berning