-
=COUNTIF error
Hi there, I have some survey results on one sheet that I'm trying to pull into another sheet so I can build charts in a dashboard to display the trend in responses (i.e. how did people respond to question 1, question 2, etc. for each event). The survey includes a drop down to select the event the respondent participated in…
-
Change Past Date into Month as Written Text
Probably a simply question but I'm looking for a formula that is able to read dates in the past, and then fill a different cell with the month as text only. e.g. The first 'offline' date would populate the offline month with 'October' Thanks
-
Changing State Based on Criteria.
Hi all, I think I have some syntax incorrect in my code and hoping for some help. Currently, I have a formula that sets the State of a task based on % Complete: "=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))" I also have an…
-
Does INDEX only work with entire column as a range?
To be clear, the correct syntax for INDEX is: INDEX(range, row_index, [ column_index ]) I have several working examples of this function across many sheets, including cross sheet formulas. I also know about using INDEX with MATCH and /or COLLECT to select the appropriate cells based on other criteria. Up to now, the range…
-
Update Formula to Check for Blank Value and Use Static Value in its Place
I have a sheet that my company uses to track when a resident is being moved from their apartment into a temporary apartment and a permanent apartment while we renovate our apartment buildings. Each resident has one row, with columns to track their original unit, original unit move out date, temp unit, temp unit move in and…
-
RYG Status Balls Formula Help!!
I am looking for help developing a formula for the following RYG Status Balls Conditions: If status is "not started", grey If it is 1 day before "due date" and status is NOT "complete", yellow If it is the day of the "due date" or past "due date", red If status is "complete", or "in progress" and it is 2 days or more away…
-
How do you use the Account Code in the Budget Management Template?
Hi, been trying to work out how to use the Account Code column in the Budget Management tracker. I need to add more rows but I'm not sure how to assign the account code for it to compute for the budget properly. Thanks!
-
Build a COUNTIFS formula
This discussion was created from comments split from: #UNPARSEABLE error.
-
Changing Drop Down Value Based On Different Date Ranges
Hi All, Is it possible to make a drop down that will change its value based on a range of dates? I need the drop down to switch between "Past Due" (> today), "This Week" (today +7), "Next Week" (between 7-14 days from today), and "Two Weeks Out" (between 7-21 days from today). Is this possible? Thanks!
-
Nested if /or formula
Hello, I am looking to have a status bar (the one with empty, half, three quarter and full) look at two columns and give a result. I have percent complete and a "Done" checkbox. the percent complete is by date, so when the date gets closer the status bar shows progress. Here is the formula I am using to do so..…