Forum Discussion
ajitsahoo8338
Helper III
Helper IIINeed help with this logic
Hello Everyone, I am trying to create logic but failed to do. I need to create a Status Column. In which there should be rows/options i.e "On-Time", "Late", "Released" "On-Time"= NOT(ISBLANK(Pr...
Uzi2019
Community Champion
Community Champion
Can you share the sample data with expected output??
It would be better working with data instead of just a logic.
you can share the simple excel file screenshot for better understanding.
ajitsahoo8338Helper III
Helper III| Project Number | Activity Number | Task Name | Resource | Baseline EndDate | Release Date |
| 226 | 3000 | Long Lead Release | MECHANICAL | 8/16/2024 0:00 | 8/16/2024 0:00 |
| 227 | 3000 | Long Lead Release | MECHANICAL | 8/16/2024 0:00 | 8/16/2024 0:00 |
| 100 | 3000 | Manuals Complete | TECH | 6/18/2024 0:00 | 6/18/2024 0:00 |
| 227 | 3001 | GA Tasks/Initial BOM | MECHANICAL | 9/13/2024 0:00 | 9/20/2024 0:00 |
| 225 | 3002 | GA Initial BOM Release | MECHANICAL | 7/29/2024 0:00 | 8/16/2024 0:00 |
| 226 | 3002 | BOM Release | MECHANICAL | 9/13/2024 0:00 | |
| 220 | 3002 | Initial BOM | MECHANICAL | 2/29/2024 0:00 | 3/29/2024 0:00 |
| 72 | 3002 | l Comp Long Lead | MECHANICAL | 5/31/2024 0:00 | 5/10/2024 0:00 |
| 131 | 3002 | Paint Scheme | MECHANICAL | 6/21/2024 0:00 | 5/2/2024 0:00 |
| 131 | 3003 | Stop Kit | ELECTRICAL | 5/31/2024 0:00 | 5/31/2024 0:00 |
| 225 | 3003 | MA Group | MECHANICAL | 9/17/2024 0:00 | |
| 132 | 3004 | Power Revision | ELECTRICAL | 7/29/2024 0:00 | 7/30/2024 0:00 |
My data looks like this. I want to create a visual table like this and add a status slicer. From that slicer, If I select On-Time then it should show On-Time rows and For Late selection it should show Late and For Released Selection, it should show those rows which have a release date