Forum Discussion

Liz_Park's avatar
Liz_Park
Copper Contributor
Oct 23, 2023

3D references

Hi all, I have a task where I have to pull information from a risk assessment report in excel to a summary page. The risk assessment itself is conditionally formatted so that concerns show in red. Th...
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Oct 23, 2023

Liz_Park 

If your tables are aligned you could define them as a 3D range 'riskTables' (say) and append them using VSTACK.  That would provide a basis for filtering the combined table

= LET(
    actions,  TAKE(VSTACK(riskTables),,-1),
    required, FILTER(actions, actions<>""),
    required
  )

That is combine the tables and choose the column you are interested in.  Then filter out all blank fields to provide a summary across projects.

Resources