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 re…
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 …
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 …
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,…
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 t…
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 i…
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 th…
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 …
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 s…
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecess…