-
Trying to add a year to this formula
So here is my current formula… =COUNTIFS({Date Completed}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Staff name}, =Staff@row ) This works. It gives me a number for all observations submitted in the month. The problem is it also counts the month for the previous year. How do i filter the count by month and year? Thank…
-
Unable to Count Blank/Empty Cells in a Column
I'm trying to count open/active events that have not been Resolved. Each event is on a separate row with a column called Resolved. Resolved Cells will either be empty/blank or contain a date & time as alphanumeric free text. Example below shows date on top of time in cell (I forced with ALT Enter after date) 3DEC 0859 ET…
-
CountIFS
I am having a problem with a formula. Does the COUNTIFS have a limit on the number of "logical expressions" used in a formula? My formula below: =COUNTIFS({Opportunity and task orders}, <>"", {2025 Opportunity Status}, OR(@cell = "8.0 - Lost", @cell = "9.0 - Client Not Selected", @cell = "5.0 Awarded Contract Vehicle",…
-
How can I get calendar view to stop showing wildly inaccurate dates?
I have a grid view and two columns are assigned to start and end dates that define some intervals that get mapped to calendar view. The dates are all formatted correctly in the grid view. The problem is that the dates that show up on the calendar view are wildly inaccurate. Certain events show up as the wrong dates,…
-
Formula to calculate task completion by owner by referencing parent rows
Hello all, I am looking for some help with a formula. I'm super close to getting it but can't figure out the last piece. Goal: I have a sheet tracking task completion and want to calculate, month by month, the percentage of tasks completed for each person. Setup: Level 1 rows = person’s name (owner of tasks) Level 2 rows =…
-
Index-Match-Collect failure
Hello - I have a formula that I use to find the next upcoming task showing as "Not Started" and assigned to "Joe Smith." It has worked seamlessly for months and now all of a sudden is returning an incorrect value and I am totally stumped as to why. Here is the formula: =INDEX([Task Name]:[Task Name],…
-
Generate documents not working
the "generate documents" function is not working, it keeps hanging in the backgound job. Same with trying to download, also keeps hanging. This is accross multiple sheets, the documents are not generated. Anyone who can assist?`
-
Recording words from Column B to Column A
Hi, I'm writing to write a formula that will record certain words that appear in column B into column A. Column B is a dropdown menu with multiple options available. I only want to record the words RED, BLUE, PURPLE, if they appear in column B and if none are present, I want the cell to remain blank. I'm struggling to know…
-
INDEX, MATCH formula referencing other sheet works incorrectly when matching formula column
Formula that I am using is the following: INDEX({Range 1}), MATCH({Search value}, {Range 2}, 0)). In this formula Range 1 and Range 2 referencing another sheet and Search value referencing the value in the current sheet. The value in the current sheet is also based on formula and when using INDEX, MATCH with search value…
-
Publish Option Missing on Grid Sheet Despite Being System Admin with Publishing Enabled
I’m running into a publishing issue that I can’t resolve, and I’m hoping someone in the community has seen this before. I am trying to publish a standard grid sheet, but the “Publish” option and the globe icon do not appear anywhere when I open the sheet. Here’s what I’ve confirmed so far: • I am the System Admin • I am…