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
2 Comments
Sorted by
Gabriel Michaudposted
about 2 months 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
2 Comments
Gabriel Michaud posted about 2 months 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
Pavel Kabir posted about 2 months ago
Hi Michelle,
See here: EXPANDPROJECTRANGE
This function can filter out inactive projects if you set the `IncludeInactive` optional argument to FALSE.
0 Votes
Login or Sign up to post a comment