-
INVALID VALUE
The column with the invalid value is a column formula. Although there are some rows where arrival and end are blank, there are a few that will give a invalid value. This is the formula =IF(AND(ARRIVAL@row <= [REF DATE]@row, [END DATE]@row >= [REF DATE]@row), [FINAL ROSE COUNT]@row, "") I would like to understand.
-
COUNTIFS with multiple IS NOT statements
Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operation. I can't figure out what I'm missing in the formula. Here's the formula that works:…
-
#Invalid Ref error in a report, but not the source
I'm seeing an invalid reference error in a report on a dashboard, but the source data is good and the vlookup is pulling in the data I want to see. Any thoughts on the cause/solution? I've narrowed down, deleted and re-created the cross sheet reference several times and the error persists. Screenshots of the error and data…
-
Auto-populating a range of columns with a number based on dates in 2 other columns.
Hi, I am having difficulty figuring out how to auto-populate a range of columns based on dates from 2 other columns. For example.. A contract's start date is Jan 2022 and its end date it October 2022. The value of the contract is 10,000 USD. I would like to populate columns Jan 2022 through October 2022 with 1,000 USD in…
-
Populate a column based on another column with check box.
Any help would be greatly appreciated. What we would like to have happen is when a check box in one of the four columns (NA, GSS Introduced, Customer Accepted, Customer Completed) is checked, it will populate a Completion field in the corresponding row. If NA is checked then Completion = 1 If GSS introduced + Customer…
-
Within the next 7 day issues
Good Evening all, I am trying to do something simple. I have a "Due Date" column. Whenever that date is within the next 7 days I would like it to check a box. However, the issues I am getting are - it is checking the boxes for due dates have no date populated as well as dates that are in the past?? Here is my current…
-
Sequential project number based on team and product name?
Hello Smart community, Trying to achieve what seems many are also working on: sequential project numbers. Below, the team is a drop down with options, the product name is manual and the result is what's below. Trying to achieve the following: UXR00 ending with a sequential number, e.g. 001... n If same team, increase 1,…
-
Consistent [Column Name] Formula
Hi, Is there a way to add like a string "[Column Name]" so whenever I add a new column that has that name the formula stays refrenced to that new column with the same name? Thank you!
-
If(AND(OR statement for Project health based on status
Need to know: Health - green, yellow, red Statuses - Defining Requirements, In Review, Reviewed, Validated There are dates that we want the project to be in the Reviewed status by. I'm trying to write a script that will allow me to set a "red", "yellow", or "green" health score based on the status of the program and the…
-
Formula to determine if created (Date) column matches a date column or is today
I have a form my team uses to record several instrument calibrations, with an auto generated created date for each entry. Is there a way to compare the created date to a date column in another sheet to see if the 2 columns match? Or maybe determine if the date in the created date column is today? I think the format of the…