Trending in Formulas and Functions
-
Count if box is checked in one column and there is a specific month year in the Month Year Column
Month Year column is a text/number format. There is a space between Month and Year in the column title and a space between month and year in the column cells, ex: 07 2025 I have tried a number of formulas and am not finding one that yields the count. Here is the most recent one I tried: =COUNTIFS([Month Year], "07 2025",โฆ
-
Dropdown menu & how to separate results
I have a dropdown menu to select a choice of up to 19 out of a possible 42 items, each item selected needs to be separated into its own column as each selection is mapped. The way the mapping has been set up is the first selection in dropdown needs to be at position 1 even if it is the 4th option and the second selectionโฆ
-
Convert Created Date to Month/Date using Local Time
We have a "Audit date" column which collects the date and time when a row is added. That currently comes through as "6/30/25 5:15 PM". We have a formula that labels a Month / Year for reporting based on the "Created Date" column. That formula currently is =YEAR([Audit Date]@row ) + " / " + MONTH([Audit Date]@row ) This hasโฆ
