-
Formula Help
HI, I need a formula for the screenshot below that looks at if 2022 Show Start Date is less than 90 days out and Rebook Plan in Place column is unchecked, assign the status column as "Red" and if checked then the status is "Green".
-
Countif the Month/Year matches the current Month/Year?
Current formula displayed at bottom. It counts the amount of Values in Range 1 that are created in the last 30 days. The formula works, however I'd like to change the second countifs statement, in particular the Today(-30) so that it matches the month/year of the date. That way, it will track the Values in Range 1 created…
-
cross sheet formula with multi-select range?
ive got a database of resources with various teams and departments people are on. in some cases there is multiple teams someone is on. How can i use HAS or CONTAINS with a cross sheet index/match?
-
Count If and Not blank
Hey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria. The columns are: Responsible Department - I want to count the cells in this column that are not blank and Program Name - Here is the Criteria - I want to count the cells in the…
-
Risk Status- Grey, Red, Yellow, Green Bubble Formula
I'm not sure why my formula isn't working. I also wonder if I can do Today(-7) in the formula. I've seen +days but not -days so maybe that's the issue? If so, how do I write it such that if the finish date is within the next 7 days, the bubble will be yellow? Here's the formula: =IF(status@row = "Not Started",…
-
Count Netdays if Project Status is "Complete"
Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date", and "Actual End Date" I have a grid with 200+ projects/rows (Project Intake Sheet), and would like the formula to…
-
Record changes to only 1 cell
In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record who changed which phase. I know that I'm able to right-click a cell to see its history,…
-
Do links/formulas update in the background without opening the sheet?
Ive built a project management system in SCC and have setup everyone to work from reports. If all goes well no one would ever go into a sheet. If no one goes into the sheets ever, would the formulas and cell links and conditional formatting, etc update still? or do these require someone to enter a sheet (not a report) and…
-
If/And Statement
Hey again, I am stuck with something a bit beyond my current skills. I need to write a formula that I believe will be an If/And Formula. The formula needs to populate the Case Status cell. If the the Tentative Return Date column is blank, the Case Status Cell should be "N/A", if the Tentative Return Date is within 10 Days…
-
How to I "not format" a number in a form?
One of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even though I typed it as 2016, 2017, 2018. The only way around it is to direct people to…