AdamApexConsultants
AdamApexConsultants
Reactions
-
Re: How to setup a Portfolio->Program->Project Structure?
hi @Synon you will need to essentially just follow the same process of the project metadata to portfolio. Meaning - on the project metadata, add a field to capture the program name. At the program le…1 · -
Re: How do I get a cell to display the value of the last cell in a column excluding one of the values?
You can use a combination of INDEX, COLLECT, and COUNTIF to find the last non-"Not Started" value in a dropdown column. Here’s a formula approach that should work: =INDEX(COLLECT(Project St…1 ·
