Hi,

I need help to solve this puzzle. I'm using this sumif formula

=SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value})

to sum up the total value of invoices against a particular order number.

I've checked that all columns are formatted as

Hi All,

I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula:

Hi All,

I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute).

Trying to get a formula to evaluate 2 columns and if the 1st column is CURRENT and the 2nd Column is CHECKED, return a value of YES, and if either column doesn't show the CURRENT of CHECKED, return a value of NO.  Have tried many combos and think I'm close  - what's missing or wrong here:

Hello,

I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desirable data management), and also to have a confirmation submission email

I need to be able to unhide one single column. NOT ALL. Is there a feature where I can pick the column I need to view. We have weekly columns that go back 2 plus years. I do not need to see over 100 columns unhidden. The unhide all feature is not useful to our

Hello. I am trying to use a COUNTIFS formula to count the number of records in a second sheet that meet two criteria; the Project Status of the record matches the project status of the row where the formula is, and the year of the Move-In Date of the record is the same as the current year. I have

I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line.  i've read a lot of the other posts but none of the formulas seem to apply or work when I input them.  Please let me know your thoughts.  Thank

Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific

Hello. I am trying to create a graph that shows the top 10 tasks ranked by the variance between Initial Duration and Actual Duration. To make this work, I want to ignore tasks that are parent records. What would this formula look like? I have created a formula to rank the Variance;