We have an Activity Table having following fields , Project_Name, Activity_name, Color_Code, Closed. All projects have equal number of multiple activities for example 20 activities.
We want to start from first activity, it should be in Red color, and when it done, its color should be turn to blue, and automatically the next acivity(which is the next row) should turn in red color.
to remind the user to work on next red acitivity.
Pls. help me how to do it.
@Rehan_Ahmed_Khan here is an idea.
Setup:
Letโs assume you have a table โActivitiesโ with the following columns.
Letโs also assume that for each project, your activities are to be executed in the order of increasing [_RowNumber]
Formatting the Rows:
The idea is to define format rule to apply to each row of your table.
In the UX section, go to the Format Rules tab, and click on the [New Format Rule] button. The trick is to define the right formula to know when to apply the rule.
For the formatting itself, check the documentation at Format Rules: The Essentials
Format Rule: Blue is 'Doneโ
That one is easy. Only apply this rule when that activity is marked as โDoneโ. Define the formula as such in the field named โIf this condition is trueโ.
Formula: [Completion] = โDoneโ
Format Rule: Red is Next
A little bit more tricky there.
For each row, you need to find:
The formula can look like this:
Formula: [_RowNumber] = MIN( SELECT( Activities[_RowNumber], AND( [ProjectID] = [_THISROW].[ProjectID], [Completion] = โToDoโ ) ) )
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |