-
Formula for SUM IFS
I am looking to write a formula that Sums a PO Amount column if PO is a number and Vendor does not equal ABC Company. Any help would be greatly appreciated!
-
INDEX/COLLECT to add Error Statement if no TDL #
Hello, and thanks in advance for your help on my formula. I do not understand why I am getting this error on my formula. I am working on adding my formula to the sheet in the first screenshot. I am referencing the sheet in the second screenshot. The 1 and 2 reference which part is which for the named ranges. I know why I…
-
Rank Vendors Based on Total Spend
Hello Community, I'm looking for formula that will rank the 'Offsetting Acct Names" by 'Supplier Total Spend'. As you can see below, I captured the total spend per supplier but need to rank these and report on the Top 10. Any assistance would be greatly appreciated!
-
How do I write this formula?
I want to write a formula that calculates the number of days we have from today until we run out of stock. I have: The number of Laptops Available The Avg Monthly Hires and I know we give out laptops at NEO every other Monday (Next one in February 17, then March 3rd, March 17th so on) How can we tell the number of days…
-
Extract Text and Number in Varying position
I need to extract text and a number to provide me with my account number. In the screenshot below shows an example of the data I am faced with. The formula will go on this sheet shown. As you can see, sometimes there is no TDL #. Sometimes the TDL # is in the front, other times in the middle, and apparently at the end…
-
Auto increment count on Column based on values appearing in another column
Hello, I am trying to add a formula to Column SSI Ref that will count and increment based on the number of times a number appears on SSI# column. I have completed the SSI Ref column for reference as to what I would like to see. Thank you
-
Update one sheet based on two columns from another sheet
Hello I have a request sheet and a review sheet. The request sheet generates a task number after submission of a new row. That task number will be manually inputted into another sheet. Once a review is done of the request, the user hits review complete. I want that checkbox (once its clicked on the review sheet) to get…
-
Formula Question
I am trying to build a Finance sheet for a project and I want to be able to type in the project code and to pull the info from the Metadata sheet into the finance sheet. I am using a combination of the Project Management Office template set and ones I have created. I have tried to use the existing formula in the Metadata…
-
JOIN(INDEX cross sheet with multi select criteria
I am attempting to match multi select criteria in one sheet to the corresponding contact list in another sheet. The multi select column has over 100 possible criteria, though the average cell has 3-4 selected. There are some circumstances that the formula will need to return two or more names. I can't make JOIN(COLLECT…
-
Formula to mark duplicates with a Status of 2 or 3
Hi Everyone, Hoping I can explain this well so that someone out there can help me with this. I have built a solution that is quite complex and moves projects around to 3 different sheets. The intake sheet generates a project ID and then when the project gets to a certain stage, it copies to my Active project sheet, but…
