Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number m…
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, {Proj…
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!
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 t…
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 (Cancel…
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 …
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".
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 Mont…
I would like to create a master project rollup to 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 h…
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 ba…
