-
Suggestion — Add a formula to retrieve information about the comments in a row
It would occasionally be useful to be able to access information about comments within a formula. For instance: IF(CountRowComments() gt 0, "Has comments!", "No comments") Or even, IF(GetComment(1).Contains('error'), TBD, TBD) (Don't take the syntax too literally, but hopefully you get the idea.)
-
Combining CountIfs statement with Date
I have a CountIfs formula that I'm having trouble getting to work when I add a date condition into it. Basically I'm trying to get a MTD output based on several countifs as well as only counting if an adjecent cell does not contain "Appointment Allowcated". The formula works perfectly when I don't have the IFERROR…
-
Formula based on timelines (start and end dates)
I'm trying to basically show sr. mgnt how many high project projects are all happening at the same time -- ideally I'd like to count them -- is there an easy way to do that? Essentially I'm using project type = High then want to show those start and end dates that fall w/in maybe a quarter range. Is that possible? TIA!
-
Using COUNTIF children to change a Status with multi criteria
Hello! In our Timing and Action we have a formula that indicates the status of a Parent row based off the cumulative Status choices (Not Started, In Progress, Complete, N/A) of the Children Rows below it. How do I get the formula to register the Parent Row 'Complete" when the CHILDREN Rows = both Complete and N/A I want to…
-
Always pull in the value from the same cell
I'm trying to pull in a text value form a 2nd sheet. The value I'm trying to pull will always be in cell [TextToPullIn]1 for example. That second sheet is populated by a form with the latest entry always on top, and the text I want to pull in my first sheet will therefore always be in the same cell. Any ideas? Maybe I'm…
-
RAG Range Formula?
Hi I have a RAG legend which looks like this-: 0-49% = Red 50-79% = Amber 80-100% = Green Like below I have a formula on my sheet which calculates a percentage on a monthly basis. I want the percentage to show in the next cell the relevant RAG e.g. 82% would be green or 55% would be amber. What is the best functions to use…
-
Remove absolute locking from a Range of Cells
I have a file, where I made the mistake of "Absolute locking" all of the formulas, before realizing that I am going to have to duplicate this chart other regions. Below is of "NED." I need to copy 2 more of these tables (for "central" & "west", ideally in the same sheet, so its easier to maintain down the road. As well as…
-
Need help with COUNTIFS formula
Hello! I have 2 fields, "Confirmed" (checkbox) and "Status" (drop-down values) to evaluate. In a 3rd field "# Waiting to be processed", I need a formula to return only the count of those records where "Confirmed" is checked and the "Status" field is blank which means "Status" has not been assigned yet Essentially, this…
-
SUMIF #NOMATCH Error
Hi, I'm running into issues when trying to use as SUMIF function in my sheet summary. I need to have it add together all the percentages"Capacity Rating." The goal is to be able to create a SUMIF for each project manager in the division so we can see what their workload capacity is before assigning projects. I've used the…
-
How to get an approval after a decline in the automated approval request workflow?
Hi All, I have created an automated workflow based on a form submission that asks for the Approval of at least 3 individuals/roles. If an Approver declines, it will send and update request to the originator (Project Manager) and ask them to update information in the form. Once the Project Manager has updated the form, the…