Best Of
Re: Getting Invalid Operation using Countifs with two fields
The syntax is subtly off. The format is =COUNTIFS(Range1, Criterion1, Range2, Criterion2, ….) So in your formula, replace the = (equals) signs inside the parentheses with , (comma). There is also another thing to consider - is "100%" is a number, even if formatted as a percent. So when you fix the formatting error, the quotation marks might result in the formula returning 0 (depending on how you've set up your sheet). So that's one other thing you may want to investigate while troubleshooting.
More info about COUNTIFS:
Good luck!
Kerry St. Thomas
Re: Column Links Now Generally Available!
I'd also LOVE to see this in Grid view! That's where the money is at! Love seeing enhancements coming out the door though! Do you have members that you review enhancements with to get their feedback while in design phase? i'd love to be apart of that!
Cayla Davis
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