Best Of
Re: How to sum information from another sheet
What you actually need is a JOIN/COLLECT and not any of the SUM functions.
=JOIN(COLLECT({Source Sheet Column To Join}, {Source Sheet Period Column}, @cell = "P1"), CHAR(10))
Paul Newcome
Re: Looking for a review on the Work Apps feature
So anyone using the WorkApp to view the information would be considered a Collaborator. For example, if you have 100 people who have access to WorkApp, then you have the potential to need a 100-collaborator pack.
The collaborator packs are not tied to your Smartsheet licensed users but to anyone who views the information using the WorkApp.
In my example above, the chances of every single user accessing the WorkApp each month are slim, so you could adjust the number as needed. In addition, the Admin screen shows how many users have accessed the WorkApp and used a collaborator slot for the current month.
Frank S.
Re: Looking for a review on the Work Apps feature
Greetings @CamSME,
As a frequent implementor of WorkApps, it is a potent tool, especially if you are trying to convey information to specific groups of users and must present it in both a computer and mobile experience.
I utilize it to share project information with stakeholders across the state, including contractors outside the agency. It allows me to tailor the information to specific groups in a single location.
It integrates seamlessly with Smartsheet assets except for Dynamic views, which we have asked for to be changed.
One of the things to consider that Smartsheet is not clear about is the number of Collaborators you will need to purchase. Collaborators are the people who will use the WorkApp during the month, and Smartsheet has bundle packages. There is a cost, so include this in your cost analysis. The good news is that the collaborators reset each month, so it is not tied to a specific user.
I hope this helps.
Thanks,
Frank
Frank S.
Re: Join us as we celebrate Gartner Peer Insights Customers' Choice 2023 🥳 Enter to win swag
My favorite Smartsheet moment was when a friend told me about the 'URL query string to prefill different default values for the same form' - changed my life..
I had around 1000 forms for our Customer Survey Program, after this tip........Down to 28 Forms!!!!
Can you imagine trying to make the smallest change in 1000 different forms??? Well not anymore😎
So there are some incredible tips out there from incredible people, learning new capabilities every day with Smarsheet.
Itai Perez
Re: Importing from Excel works one way, but not another?
Hi @jmhoward
I hope you're well and safe!
Strange!
If you haven’t already, I recommend submitting a support ticket through the new Smartsheet Support Portal.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community 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!
Andrée Starå
Re: Importing from Excel works one way, but not another?
I find that the sheet will pull in as expected, but I need to enter data into at least 1 cell, in order for things to save / be accessible later. As soon as you do it, you would find the sheet to be accessible / findable in the search.
Re: Impossible to countifs on an empty column
Try tucking the last condition inside the COUNTIFS closing paren.
=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0", {TgtDate}, ""))
Carson Penticuff
Report not printing as shown on screen
I have created a report with one group and two summaries. It looks good on my screen but when I go to print the report, it does not show the grouping or the summaries. I have deleted the report and recreated it and it still does print correctly. I also tried to export to a .pdf or Excel and neither one of those reports were correct either.
Can someone help me get this report to print like what is on the screen?
Thanks,
Janelle
Janelle
Re: Can you add a hyperlink to a cell that's linked in from another sheet?
Hey @ro.fei
The only way to have a clickable link in the same cell as other content is to have it be the fully URL displayed. This means you could have a link to a sheet and the contents from your cell-linked column if the link was the URL to the sheet:
Cheers,
Genevieve
Genevieve P.
Re: Need to remove characters from a text string that appear after >
=LEFT(Text@row, FIND(">", Text@row, 1) - 1)
Paul H

