I'm relatively new to building Velixo reports and trying to build a basic project report but can't find a formula which pulls out all projects with the status "Active". Is this possible in Velixo? I then want to use this to pull out further information on those specific projects. Thanks in advance.
0 Votes
1 Comments
Gabriel Michaudposted
5 days ago
Hi Michelle,
The EXPANDPROJECTRANGE function gives you a list of projects, and it has an argument allowing you to only exclude inactive projects.
0 Votes
I'm relatively new to building Velixo reports and trying to build a basic project report but can't find a formula which pulls out all projects with the status "Active". Is this possible in Velixo? I then want to use this to pull out further information on those specific projects. Thanks in advance.
0 Votes
1 Comments
Gabriel Michaud posted 5 days ago
Hi Michelle,
The EXPANDPROJECTRANGE function gives you a list of projects, and it has an argument allowing you to only exclude inactive projects.
I recorded a video showcasing this. Video is here: https://www.loom.com/share/6e19d7ac4edc4e838981c43a7ff6b44f The demo I built in the video can be found attached.
Attachments (1)
Sample project report.xlsx
19.9 KB
0 Votes
Login or Sign up to post a comment