Best Of
A Reference field should be used to show conversations "@ messages" in Teams
Hi,
Every time a comment is coming from Smartsheet into Teams comes with no reference whatsoever making it difficult to track right away forcing users to open the Smartsheet item to really see where -what row- it is coming from wasting time & adding redundancy if they already have that Smartsheet item open.
Suggestion to use/enable a reference field such as the Primary column or others to immediately see the row where it is coming from that conversation. See attached.
Cruz Ortiz
Is there a way to export column descriptions with the sheet?
For data export needs, I was trying to see if it was possible to export the column descriptions when I export a Smartsheet to Excel. I know it will export comments and the sheet summary. Anyone know if exporting column descriptions with a sheet are possible?
newm6649
Re: Data Shuttle filter for dates after a certain date?
@RAdamowicz No, they do not need to be formatted that way in the Excel or Smartsheet. It's purely how you format the filter in Data Shuttle.
Let me know if that works or if you ahve any issues!
Darren Mullen
Re: How do I update a status based on 3 different approvals.
Hi,
I hope you're well and safe!
To add to Tomasz's excellent advice/answer.
Another option could be using Workflows instead; you don't need formulas.
Also, a method I use if the Approvers are beside each other is to count the approvals instead.
=IF(COUNTIFS([Approver 1]@row:[Approver 3]@row, "Approved") = 3, "Approved", "Not Approved")
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Ability to Favorite a Collection
The Collections feature is amazing - we love it! It makes it so much easier for those who are not familiar with Smartsheet to get what they need and not be distracted by other sheets and workspaces they may have access to. However, it would be even better, if they had the ability to favorite it so they could find it easily. Currently, they must have the link or know which workspace to open to find it.
KLaLa
Re: Collect an column entry when data is entered by a form
Thank you, thank you! It seems to have worked, at least in my test sheet. You have saved me many hours of cursing at the computer!
A&W Admin
Re: Formula Help! (CHeck / UnCheck At Risk)
Hi,
I hope you're well and safe!
The change cell action doesn't work with the Symbol column type, so you need to create a workaround.
If you add a so-called helper column and have the change cell action changing that to, for example, Red, and then use a formula in the Symbol column to reference the helper, it will show the Red circle.
Make sense?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Re: Add Explicit Automation Order Execution
I'd like to see a feature where I could make a call out from one workflow to an existing workflow. Due the current limitations within the existing workflow feature, being able to "link" different workflows together will allow for more complex automation such as nested if, If/then/else, or automation of multiple field population.
ReneRCCD
Critical path in a report
Hello there,
I am looking for a way to show my critical path on my dashboard. I assume I need to create a report of critical path. the question is; how can I filter my critical path in a report. My aim is to have this automatically show it, updated, every time I open my dashboard.
Is there any attribute related critical path on a row?
Mehran Bagherian
Re: Critical path in a report
Hi,
Any update as to whether the Critical Path & Dependencies can be added into the report?
Robert Poddar