-
Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test") I'm not working in excel - I just wrote up the…
-
if and formula help required
Hi there, i have the following formula that i cant get to work. basically, i am raising a flag if a job is at one of multiple defined stages and withing a specific timeframe. its the multiple stages bit that i am stuck with. current formula as follows =IF(AND($[Cust Requested Date]$1 + $[Column54]$9 > [Cust Requested…
-
Count Ifs Formulas
I have created formulas to count the number of incoming quotes by month and according to if they have been Won/Lost/Pending. I use the exact same formula for March (month 3) and it works beautifully. For some reason the formula is not pulling in the info we have loaded up so far in April: =COUNTIFS([Conversion…
-
Adding hours and minutes
Hello All, I am new to SS and am trying to figure out how to add these hours and minutes for the year (there will be more added each week). I have found some posts saying this is not possible but they are from last year. Has anyone mastered this issue? [**Malformed image removed by moderator**]
-
Yet another RYG Balls Question
Hi all, Can someone either let me know or point in the direction of a post that would assist me in solving for the following. I am trying to create a formula that would: * Return red ball if date in a column titled "Last contacted" contains a date that is 30 days or over. * Return a yellow ball if the same column has a…
-
Formula Help
I have one column with a person's first name, then I have another column that I want to be just the first initial of the previous column's first person's name. Instead of typing in the first initial every time, I want to know if there is a formula I can put in the initial column??
-
How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via
Hi All I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me. Did any of you faced a similar problem? What…
-
Weeks/Days Remaining Formula
How can I create a column that displays "x Weeks and x Days remaining" until a task's start date? I know about RYG Balls and what I can do with conditional formatting, but those just aren't sufficient for my needs. In Excel/Sheets I use the MOD function to do this using the following formula: =IF(([Start…
-
Conditional Formatting or Formula
Good Day All: I am trying to use Greater Than Conditional Formatting for two columns. However, Conditional Formatting does not allow you to select 2 columns. Perhaps, I have to use a formula? Here is what I would like to do: If % Complete (Planned) is Greater than % Complete (Actual), then Red If % Complete (Planned) is…
-
Date Calculation \ Automated based upon cell value
Good day Everyone: I have a field set up with automated current date, that is used to calcuate\count the # of days of task duration based on current date and task start date. trying to figure out a way to have Actual duration stop counting once the “Sate” of that task.. reflects “Completed”. Or Actual Duration stops…
