-
Add an Alt-Enter to a Formula?
I have a formula that is pulling a status update from 3 different sheets: =IFERROR("BA: " + INDEX({ITBA Status}, MATCH($[Project / Task ID]@row, {ITBA PID}, 0)), "") + IFERROR(" AppDev: " + INDEX({Dev Status}, MATCH($[Project / Task ID]@row, {Dev PID1}, 0)), "") + IFERROR(" CS: " + INDEX({CSStatus}, MATCH($[Project / Task…
-
Updating a status column based on Values in Expected % Complete and % Complete
I have dates from two columns, Expected % Complete, and % Complete which I want to use, and populate the Status Column (Dropdown) using Formulas: The Dropdown options are " Not Started", "Behind", "On Track", and "Complete". I tried using the below formula =IF(AND([% Complete]@row = "100%", ([Expected % Complete]@row <…
-
Cross sheet formula to allow a series of data to be pulled into 1 cell
This is my formula: =IF(Staff4 <> "", VLOOKUP(Staff4, {Sheet - PTO & Project Staffing Range 1}, 56, false), "") I need to see all the data in Staffing Range that Staff4 is working on. Right now, I have it naming the first name in that column. I want it to list all the different names of projects that Kate is working on.…
-
Formula to calculate fiscal quarter
Hello! I am trying to create an IF statement to show the federal fiscal quarter an event occurred. Could someone please help troubleshoot my syntax? Federal Quarters: Q1: Oct, Nov, Dec (10, 11, 12) Q2: 1, 2, 3 Q3: 4, 5, 6 Q4: 7, 8, 9 Not working syntax =IF(MONTH([6m NOMs Date]@row) = >10, 1, IF(MONTH([6m NOMs Date]@row) <…
-
Do I use CountIf to count the number of patients in any given month?
I can't find a formula that works to do a tally of how many patients I had in each month. Would I do a COUNT and then somehow determine it by month? Help please??? :)
-
I save a column but it keep returning to previous change
I was trying some changes in my start date column, so i turned my auto numbering to manual date, then I'm trying to turn to auto numbering but it aways changes back to manual date. am I missing something? is it normal?
-
Using Countif and if to count text then format result compared to another cell
Hi I have a countif formula =COUNTIF(Wed10:Wed51, "HPT" to count the number of times HPT shows in a column. I want to format the result by color compared to another cell. For example: i need 5 however; the countif returns 4(counts 4 HPT in the column) I want the 4 to show red, if it's equal = black, if it's higher than…
-
Creating a widget
Hi, I need assistance in creating a widget for a dashboard. So basically I have got a sheet with close to 2000 rows and each of those rows have action owners, due dates, etc. I would like to create a widget that would show when the actions are due and who the action owners are (action owners vs due date). Can anyone…
-
COUNTIFS and SUMIFS with a Date Range
Hello, I'm trying to count the number of cells that have a date in the year 2020. This is the formula that is returning "0" which is incorrect: =COUNTIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], >=DATE(2020, 1, 1)) Additionally, I want to sum the values that correspond to this date range, and…
-
Formula "Countif" with value bigger than "current date"
I use a sheet summary and want to figure out how many cells are there with a date bigger than the current date my formula =COUNTIF(Start1:Start195; > TODAY) doesn't work. Why? kind regards Joerg
