Nick Korna
Nick Korna
Reactions
-
Re: Counting occurrences for each month for this year only
Hi @Erica Cole, What error is your formula giving? Your formula should work (the month/year order doesn't matter) so either of the below should be valid: =COUNTIFS({Sourcer}, "JJ", {Sourced…1 · -
Re: Count the number of rows where a column (multi select dropdown) has more than one value
Hi @latheobald89201, This should work: =COUNTIF({Attendee Role}, COUNTM(@cell) >= 2) Hope this helps, but if you have any problems then post what they are! 😊2 · -
Re: How to show 5 different sets of checkboxes in same column?
Hi @22Wordsmith, You can somewhat do this. If your subject data is in tick box columns, then you can use a formula to combine them and using wrap: The formula in the Subjects column being: =IF(Readin…1 · -
Re: How to create a formula column that calculates the difference between rows?
Hi @sweta22, You can use SUMIFS for this. Doing the formulas in the same sheet: =IFERROR(100 - ((SUMIFS([Last FY - Jun]:[Last FY - Jun], [Metric Name]:[Metric Name], [Metric Name 2]@row, [Plan - Actu…1 · -
Re: Return "Yes" if a date range includes a certain month
Hi @O.Nash, Bit of a throwback, but it'd probably be easier to do something like this (again, using Jan 2023 as an example): =IF(AND([Start Date]@row < DATE(2023, 2, 1) - 1, [End Date]@row >= D…1 ·
