Hello
I am using the below formula to return the next action date from a table and this works as expect
So I am stuck on the following, in the table I am looking up (tbActions) I have an Id column (Id) that I also need to return based on the next date. I am reaching out for suggestions so that the 'Action Item' Column now includes the Id
Thanks in advance
Dan
I am using the below formula to return the next action date from a table and this works as expect

Excel Formula:
=IFNA(INDEX(tbActions[Action Date],MATCH(MIN(IF(tbActions[Pillar]=C7,IF(tbActions[Status]<>"Completed", ABS(tbActions[Action Date]-TODAY())))),IF(tbActions[Pillar]=C7,IF(tbActions[Status]<>"Completed",ABS(tbActions[Action Date]-TODAY()))),0)),"None")
So I am stuck on the following, in the table I am looking up (tbActions) I have an Id column (Id) that I also need to return based on the next date. I am reaching out for suggestions so that the 'Action Item' Column now includes the Id
Thanks in advance
Dan
Last edited: