Best Of
Re: Formula
Are you able to provide screenshots for context?
Your MATCH functions are off. The first piece should be either a "text string" or some other data or a cell reference to something on the same sheet as the formula, not a {Cross Sheet Reference}.
Similar (but reversed) idea for the first range in your INDEX function. Generally that is going to be a {Cross Sheet Reference} pointing to the same sheet as the second piece in your MATCH function.
=INDEX({Planned Date}, MATCH([Heritage Field Trip]@row, {Index Match Helper}, 0))
Paul Newcome
Re: May Question of the Month - Join the conversation and receive a badge
I work with books of information to make it a page instead of a book.
Nathan Slatton
Widget storage for dashboards
It would be helpful to have a storage option /space for dashboard widgets. Some months I have charts for various units, other months I need a text box with title to show there is nothing to report this time. Widget storage would make dashboard updates much faster.
22Wordsmith
Re: User Subscription Model Change - Implications on your business?
For me, managing a global enterprise, the cost increase brings it close to a full blown ERP system. It's a sad time for me since I've been a loyal Smartsheet user/admin since 2009, but all things must end. We are going to have to start moving users off of Smartsheet and restricting who uses it, until we land on a replacement. Like I said, I manage a global enterprise and Smartsheet is one of many tools that are currently being used, so it's a mater of moving people over to another existing platform. And for all the other platforms we have, why is Smartsheet so much more than the rest of them?
@D.Connor bringing themselves inline with competitors = loosing their competitive advantage.
earl_bennett
Re: Bridge and Get Sharepoint List Items - No pagination?
Oh yea that's a great idea! It makes sense that Power Automate gracefully handles that API call with pagination.
Thanks for explaining that option, so that other people can find it in the future!
SSFeatures
Re: Bridge and Get Sharepoint List Items - No pagination?
Hey @Darren Mullen, I think that your assessment is completely accurate.
In this thread Genevieve points out the same limitation, so you might need to perform the API call directly rather than using the SharePoint module.
Here's a link to the SharePoint API documentation for using the $skiptoken to fetch paginated list items:
Hope this helps!
SSFeatures
Bridge and Get Sharepoint List Items - No pagination?
I'm trying out Bridge's Sharepoint module to get items from a Sharepoint list. The response from Sharepoint only returns a maximum of 200 items.
And the issue is that there doesn't seem to be ANY information in the response about Number of items or pagination.
So… really unsure how this is useful for more than 200 items :)
Seems it will just have to be an API call or am I missing something with this Sharepoint module in Bridge? I do miss obvious settings from time to time. I've looked several times but see nothing about pagination however…
Darren Mullen
Smartsheet Bot on MS Teams Access for EU Users
Hi,
I understand from the support team that Smartsheet EU users cannot currently utilise the personal notifications on the Smartsheet Bot in Teams feature. It's a great feature that will enhance the team collaboration and engagement with various Smartsheet assets and notifications directly within Teams.
This would be a fantastic feature for all of us in the Smartsheet EU to have. Looking forward to the community support on this.
Regards
Guru Rajendra.K
gururajendrak
Group management: a small list of suggested enhancements
I have already submitted these to the product feedback form.
Group management could be made a whole lot easier.
- A group admin should be able to maintain a group by listing people in a sheet made for that purpose.
- Should also be able to export a CSV file of group members (for auditing purposes).
- Group members should be listed in alphabetic order in a group.
- Group membership should also be an option for contact drop down lists - either single or multi-select. i.e. I have a contact drop down, and I want to specify that it be populated from the members of a particular group.
Large groups are very difficult to manage. Members aren't even listed in alphabetic order, so visually scanning a group to audit it is very time consuming.
Bruce Northcote
Re: Combine two pro plans under the same pro plan
The information above from 2023 is specific to Pro Plans on the Legacy Collaborator Model. Here's the Help Article with more information:
In this instance, as long as the users who owned sheets on the second plan still have licenses in the new plan, then all of those owned sheets will stay the same: same URL, same workflows, same forms, etc. 🙂
If you have a very specific scenario to go through, you can reach out to Smartsheet Support with the information about both plans (what type, what model, number of users, etc) and they can help clarify the process in your instance.
Cheers,
Genevieve
Genevieve P.