Sign in to join the conversation:
I am trying to create a unique list by removing duplicates followed Paul's steps.
Following is not returning any value. Please advise what is wrong
=IFERROR(IF(ISNUMBER(RowID@row), INDEX({CIS_SRF_Offshore CustomerName}, MATCH(RowID@row, {CIS_Offshore Helper}, 0))), "")
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
