Automatically assign codes

A
Andreas Ronczka 👤 Member for 19 years 11 months

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

T
Tom Howard 👤 Member for 22 years 11 months

Use the progress token called "Process State"... titles cant be changed but represent similar headings to those you require.

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