Automatically assign codes
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
You could also use a column with the token "priority" in the spreadsheet and set in the field "indirection" the formula "Percent complete#0#99".
As result you get a colum where 0% shows RED, 1-99% shows ORANGE and 100% shows GREEN. Not a code but looks simelar.
HTH
Andi
Use the progress token called "Process State"... titles cant be changed but represent similar headings to those you require.