Best Of
Re: Retrieve Date from a Report to a different Grid Sheet
You would need to have unique IDs on every row. Then you can use something along the lines of
=IFERROR(IFERROR(IFERROR(INDEX({Sheet A Column To Pull}, MATCH([Unique ID]@row, {Sheet A Unique ID}, 0)), INDEX({Sheet B Column To Pull}, MATCH([Unique ID]@row, {Sheet B Unique ID}, 0))), INDEX({Sheet C Column To Pull}, MATCH([Unique ID]@row, {Sheet C Unique ID}, 0))), "")
You can set up a copy row automation on sheets A-C to automatically copy rows based on a trigger.
Paul Newcome
Re: Fonctions: FIND vs CONTAINS
Hey @Cbastien
I wondered if you need to use either CONTAINS or Find. Is the value in [Type] in a single select dropdown, that is , a drop down where only one answer is allowed at a time?
If so, CONTAINS or FIND isn't required.
=SUMIFS([ITEM qty]:[ITEM qty]; [COMPLETED]:[COMPLETED]; <>0; [DEFINITION]:[DEFINITION]; TYPE@row)
If this works for you, this it is more efficient than searching with CONTAINS or FIND.
Kelly
Kelly Moore
Re: Nesting Child Rows Automatically from a Form Submission
You're more than welcome!
I'd be happy to share an example.
Please send me an email at andree@workbold.com, and I'll share it with you.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: My dedication to the Smartsheet Community
@Andrée Starå Thank you! I'm not sure if I know anything you don't already know about Smartsheet 😊
Darren Mullen
Re: Notifications from Workflows: choose if fields display horizontally or vertically
Thanks for responding, the first option, "all fields" is not practical. Normally our sheets have a minimum of 25 fields/columns. When the workflow is sent, we focus on the fields that are normally blank (2nd stage of process), and would need to be entered. So I normally select the 2nd option, which lists everything horizontally. I want these fields to be listed vertically. It provides a "cleaner look".
Sherry Fox
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å