Best Of
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
Re: Return information from a cell from another sheet, by using a ref no. created by an autonumber colum
@Paul Newcome I finally figured it out! Thanks for trying to help me, I appreciate it!
This is the final formula:
=IFERROR(INDEX(COLLECT({COMPLETED ACTIONS Partners & CHPs Range 2}, {COMPLETED ACTIONS Partners & CHPs Range 3}, MAX(COLLECT({COMPLETED ACTIONS Partners & CHPs Range 3}, {COMPLETED ACTIONS Partners & CHPs Range 5}, [Helper Column]@row)), {COMPLETED ACTIONS Partners & CHPs Range 5}, [Helper Column]@row), 1), "")
A.Turner
Re: In work Formula
Hello @Dustin Jenkins
Glad I could help you with the below and enhance with the Status column in the underlying source sheet.
=IF(AND(HAS({V-22 Mod WIP Range 5}, "Inducted"), HAS({V-22 Mod WIP Range 1}, "168675"), HAS({V-22 Mod WIP Range 4}, "TCAS A2")), "In Work", "")
I am thinking that you can bring in the 2 columns with indicator symbols using Join embedded with Collect. You may have to add the column in the aggregated sheet and hide it.
Video Editing Software Discussion in Smartsheet Community
Hello Smartsheet Community,
I wanted to kick off a discussion about video editing software, and how it can complement our project management efforts in Smartsheet. Here are a few topics to consider:
- Favorite Software: What video editing tools do you use? How do they integrate with your projects in Smartsheet?
- Tips and Tricks: For those who edit videos regularly, what tips or best practices do you have for efficient editing? Any specific features in your software that you find particularly helpful?
- Project Examples: Have you used video editing in any of your Smartsheet projects? I’d love to hear how it enhanced your presentations or reports.
- Challenges: What challenges have you faced when combining video editing with project management? How did you overcome them?
- Learning Resources: Any tutorials or resources you recommend for improving video editing skills?
Looking forward to hearing your experiences and insights!
williamjames7145
Re: Help with "Syntax not quite right"
Try this.
=IF(Hierarchy@row > 1, INDEX(ANCESTORS(Task@row), 2))
Does this work for you?
Kelly
Kelly Moore