skitheast13
New Member
- Joined
- Jan 20, 2023
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hello All,
Some of the deals in the table below will only provide either the financial statements or the quarterly report. Some deals will provide both.
For those deals that only provide one type, I would like to reflect the date the report is provided in both financials/reports columns.
In other words, on sheet 1, if cell in column B = yes, cells in columns C & D should reflect the same date even if only one of the types of reports has been received.
However, if cell in column B is blank, the cells should be able to populate dates individually if both types of reports are received.
I wanted to use an isnumber formula to check if there was a date in either cell already, and to just populate that date if there already is one. But obviously referencing the opposite cell is causing a circular reference. Is there a way to do this formulaically?
Sheet 1, summary with lookups up to sheet 2:
Sheet 2, data sheet with dates:
Thank you for your help!
Some of the deals in the table below will only provide either the financial statements or the quarterly report. Some deals will provide both.
For those deals that only provide one type, I would like to reflect the date the report is provided in both financials/reports columns.
In other words, on sheet 1, if cell in column B = yes, cells in columns C & D should reflect the same date even if only one of the types of reports has been received.
However, if cell in column B is blank, the cells should be able to populate dates individually if both types of reports are received.
I wanted to use an isnumber formula to check if there was a date in either cell already, and to just populate that date if there already is one. But obviously referencing the opposite cell is causing a circular reference. Is there a way to do this formulaically?
Sheet 1, summary with lookups up to sheet 2:
| Deal | Receives Only One Report | Financials Received Date | Report Received Date |
| Greyes | Yes | 4/17/2023 | |
| Redwood | Yes | 5/28/2023 | |
| Rocket | Yes | 5/29/2023 | |
| Recon | 6/30/2023 | 6/30/2023 | |
| Tinted | Yes | 8/10/2023 |
Sheet 2, data sheet with dates:
| Deal | Financials Received Date | Report Received Date |
| Greyes | 4/17/2023 | |
| Redwood | 5/28/2023 | |
| Rocket | 5/29/2023 | |
| Recon | 6/30/2023 | 6/30/2023 |
| Tinted | 8/10/2023 |
Thank you for your help!
(I changed the value for Recon on sheet 2 & it seemed to pick up the different date)
