-
Formula Help
Hi All, I have an approval column which which clicked on, would like to have a tick/cross at the beginning of the row.. Essentially, if CSG Approval (Column 1) is approved, a green tick (as yes in column properties) should appear in Project Approval (column 2) vice versa, if rejected, should have a red cross (as no in…
-
MAX Function Error (#INVALID COLUMN VALUE)
Hello, I am working on creating a project plan. Instead of having the singular Status Update field that comes with the project plan template, I wanted to keep a log of status updates, then reflect the most recent info from that log in my project plan. I created a new sheet/grid with 3 columns. Weekly Comment, (automatic)…
-
Nested IF / AND / OR formula help needed
I need to create a formula which drives the RGG ball in the Contact Compliance Status" field based upon RGG values in the previous 6 columns, based upon the following. Possible Values in the 6 previous columns will be Green, Red, Gray or blank: I've tried several versions of =IF(AND(OR ... but haven't been successful. Any…
-
SUMIFS Formula for Rows Assigned to Multiple Contacts
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now that I have lines with multiple contacts assigned to them it will not recognize even the one employee's name anymore. I…
-
Index/Match/Max/Collect
Hi all, I am having trouble putting together a formula and I am hoping someone here can guide me in the right direction. We have a sheet that we enter payments we receive from our customers. That sheet has the customer name, check date, deposit date and amount etc. I am looking to create a sheet that can give me the latest…
-
Using COUNTIF in Sheet Summary
I am trying to use a COUNTIF formula in the Sheet Summary. I have a column called, "Current Project Status." I want to count the total number of times the word "Operational" appears in that column. I have entered this into the field with no luck; "=COUNTIF(Current Project Status:Current Project Status,Operational)" I have…
-
Return Blank in column
Hello, I am trying to populate a Pass/Fail Column based of the answers in a pervious column. I am using IF formula, =IF([1. Pass Meds]@row = "Yes", "Pass", "Fail") but not sure how I should add in if blank. Any help is much appreciated!
-
Counting Dates within a Date column
Hi all, I'm trying to set up a formula that counts specific dates within a date column, using the following approach: =COUNTIF({Reference 1}, "31-12-2020") It keeps returning 0 when there are least 4 dates within the target column that match the specified criteria. Can anyone advise how I can fix this? Many thanks in…
-
End of Year Rollover
Good afternoon, I have been given the task to do a year end rollover. This has me duplicating each sheet, but then having to go in and change formulas for the additional sheets I'm creating. This is a very time consuming task, and I'm sure there has to be an easier way. After googling and trial and error, I have yet to…
-
Formula's won't work together
Hi! I need to get the below formula to capture both project stages but when I add them together it gives me zero which is incorrect. I need the metric to match the report on the dashboard, any help is appreciated! =COUNTIFS({HR Projects - PMO Range 4}, >=TODAY(1), {HR Projects - PMO Range 4}, <=TODAY((30)), {HR Projects -…