Hello, I am looking to change the way my project app works. I am wanting to make a single table that holds the project information, lead information, and job information.
Every project gets its base information, it becomes a lead, and if accepted becomes a job.
In this table I will add an enumlist which I can select which stage/s its currently at.
I will use slices in the project, lead and job views to filter only relevant information for each team.
However, if I create a project, I don’t want it to become instantly available to view in the job view. Am I able to filter using the enumlist? So if the stage is not selected to job, it won’t show under the jobs view?
Solved! Go to Solution.
You might try either of the following:
IN([Lead Status], {"Requires Inspection", "Ongoing Lead", "Lead Completed"})
or:
NOT("Currently not a Lead" = [Lead Status])
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |