Sam_McDonnell - profile

Sam_McDonnell · Jul 25, 2018

I’m currently manually entering labels for all dated entries so I have a single select with Sept 2017, Oct 2017 etc

Sam_McDonnell · May 10, 2018

I have a sheet called fixtures and it is filtered into seasons, each entry represents one match and has players listed that played in a match. I want to be able to count how many times a player appeared in a each season. Any ideas? The seasons are cu...

Sam_McDonnell · Jan 12, 2018

I have 11 columns of linked records (a football team lineup), with a player in each slot of each column. Is it possible to calculate how many times the same name appears in all the columns in total in the separate linked players sheet?

Sam_McDonnell · Jul 26, 2018

Thanks, the more I look at it a single select isn’t vital. The being able to group and filter is more important. I hate to be ignorant but could you explain how I use the DATETIME_FORMAT() formula?

Sam_McDonnell · Jul 26, 2018

I currently have a date for each entry, next to the entry I would like an automatic “Month/Year” So… 26/07/2018 and in the next cell automatically… “July 2018” so I can easily group entries together by their month.

Sam_McDonnell · May 15, 2018

I just have three additional fields for the subs, and discount any subs who were not brought on. Regards, Sam

Sam_McDonnell · May 14, 2018

Thanks @Andre_Zijlstra, that looks like the route I should be pursuing. One difference is I have 11 fields for the different starters rather than linking them all in the same field. I’m sure there’s a work around for this. Thanks again for your help.

Sam_McDonnell · May 11, 2018

@Andre_Zijlstra thanks, that’s very similar to what I have. The main difference is I have 13 seasons of fixtures with each season identified by a single select field. I’m looking to count players appearances by season, any ideas?

User Statistics

User Activity

Is there any way to display the date of an entry as a single select?

Can I count how many times something appear in a range of entries?

Query on summing/rolling up multiple linked record columns

Re: Is there any way to display the date of an entry as a single select?

Re: Is there any way to display the date of an entry as a single select?

Re: Can I count how many times something appear in a range of entries?

Re: Can I count how many times something appear in a range of entries?

Re: Can I count how many times something appear in a range of entries?