Karenmst
Karenmst
Reactions
Discussions
- Hi, I am using an INDEX MATCH equation to pull a Unique ID from my Master Contract Data sheet. The equation works well like this: =IFERROR(INDEX({Contract Master Data - Contract Unique ID}, MATCH([Con…
- Hi - I"m looking for an equation in column A to sum the value of column B for any children rows. However, if there are no children, then I would like the equation to return the value in column B. I ha…
- I am trying to build a SUMIF equation (in sheet #1) that sums data (Hours Used) from a different sheet (sheet #2) if the unique ID matches. I can successfully build the equation where the 'Range' refe…
- Hi, I am trying to write a formula that returns a specific status (text) depending on checked boxes in 3 other columns. If the column is checked, the status text should be as follows: [Invoice sent to…
- I would like to create a column with a formula that will check a box if several of the following columns contain an entry (any kind of entry). The application for this equation is to confirm completio…
