All Open RAID Log Column Automation

Nikki G

I have an All Open RAID Log report in portfolio toolkit. I have a column "PRJ Number". I need to have the number (profile data?) for each row auto-populated, from the Open RAID Report. How do I do this?

Any help is appreciated!

Auto-add PRJ Number to report below.

From Open RAID Report below

AravindGP

Hi @Nikki G

You will need to add in a formula in all your RAID sheets across projects for the PRJ Number column. The formula to use would be =INDEX({Column reference from project summary sheet containing the value}, MATCH("PRJ Number", {Column reference from project summary sheet containing the text stating PRJ Number}, 0)

Since this is a cross-sheet formula, you can't use global updates in Control Center. It will need to be done manually in each RAID sheet.

This article will help if you're not familiar with cross sheet references

Create cross-sheet references | Smartsheet Learning Center