OK, so I have two columns on multiple sheets, ESTIMATED PROJECT SIZE and ACTUAL PROJECT SIZE. On the sheet I'm working in, I have a column called PROJECT SIZE DIFFERENCE. Essentially, I want to write …
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This wi…
Hi everyone, I'm trying to map all tasks and collaborations for each employee to help them manage their workload. For collaborations, multiple employees can be tagged in a single cell. My first attemp…
I am creating a template for a daily log for our job sites. I want to find a quick way to fill in our working days into the rows so I'm not manually typing or clicking and dragging and deleting every …
Context: I have created a trendline report that counts the number of projects started each month. I've done so by building out three separate columns that determine the month and year so that I can th…
Hi All - I've been going round and round with this formula and getting the Unparseable error. My guess is that it is really simple, but I'm not finding it. I want invoices that are current, paid or le…
Hello! Trying to change the column (submitted by) values from user name to the actual persons name. I have: IF([submitted by]@row="{users log in}", SUBSTITUTE ({first and last name})) I'm getting no r…
Need the formula below to recognize that the beginning of the week is a Friday. If the "Date of Shift" lands on a Friday, then the "Week of" should be the same date. =IF(WEEKDAY([Date of Shift]@row) =…
I am still working on my same template. Now there are multiple dates that are using formulas. I would like to be able to use a formula within conditional formatting for this range. When I attempted to…
Is it possible to create an automation that triggers off a different grid (grid 2) where that information is not copied to grid number one? Example, when grid 2 column NAME says Mike send information …