- Invalid data type result when joining a complex collection
I'm receiving an "#INVALID DATA TYPE" result with the following forumla: =JOIN(COLLECT({LocationStrings}, {LocationStrings}, NOT(ISBLANK(@cell)), {PersonNames}, @cell = $[Person contact list]29, {ProjectStatus}, OR(@cell = $Status$5, @cell = $Status$6), {DeliveryDate}, AND(MONTH(@cell) = MONTH(TODAY()), YEAR(@cell) =…
- Display last value in column
Hello Community! My question is quite simple. (I hope). How can I display the last value of a column? I tried to use the formula = INDEX, but I could not read the last number automatically. Thanks!
- Help on formula: Countifs with multiple columns and criteria
Hi, So I've been working on a formula but couldn't get it right. I wanted to count the number of my projects that are Active (on-time) and Active (delayed). I get the on-time count correctly but for the delayed ones I always get a plus 1 in the results. Here's the formula I use (btw the stages represents that a project is…
- count if check box is not checked (2) and requested date is within a date range
I am trying to get a count of each row on my sheet that meets the following criteria. Children of ([Requested Date]17) (which is date format column) is between 1/1/18 - 1/31/18 and Children of (Canceled17) (which is check box format) is not checked (0) and Children of ([Not Owner]17) (which is a check box format) is not…
- Nested IF and Forms
Good morning. I created a meeting request form for business units to fill out so we can capture information we need about an upcoming conference. I'm trying to rig the way the information is captured on the sheet and am having a little trouble with the Nested IF. I have columns for each meeting date and a drop-down option…
- Referencing a predecessor in formula
Hi, I would like to change a symbol cell based on the status of a predecessor completion status i.e. "If a predecessor completion status is 100% then the status of this raw should change".
- Average of multiple rows
Hi - I am running into a problem with finding the average of multiple rows based on the two previous columns. I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would then populate the 2017 and 2018 columns by Month on the other sheet. Any ideas would be…
- Dynamic lookup for Project Master Rollup
我想创建一个主项目汇总track projects, and do not want to set up cell linking every time a new project is added. To this end can we create a dynamic lookup so all the user has to do is type the name of the sheet referencing the new project into the master rollup?
- Populate Dates Between a Start Date and Finish Date
Hi, I am trying to create an element of capacity planning for the company i work for, and am having issues with the start date and finish date. I have a master production planning sheet which has a basic start date for the job, and a finish date for the job. This shows it nicely on the gantt chart and all the days that are…
- Link limits regarding Vlookup
My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range from another sheet, do all the cells in that range count against the inbound sheet, or is it just the one cell that is…
