Asta Powerproject Member for 19 years 4 months Member for 19 years 4 months Submitted by Andreas Ronczka on Fri, 2007-02-09 09:55 Permalink RE: Automatically assign codes 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 Member for 22 years 4 months Member for 22 years 4 months Submitted by Tom Howard on Tue, 2007-01-23 07:28 Permalink RE: Automatically assign codes Use the progress token called "Process State"... titles cant be changed but represent similar headings to those you require. Log in or register to post comments
Member for 19 years 4 months Member for 19 years 4 months Submitted by Andreas Ronczka on Fri, 2007-02-09 09:55 Permalink RE: Automatically assign codes 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
Member for 22 years 4 months Member for 22 years 4 months Submitted by Tom Howard on Tue, 2007-01-23 07:28 Permalink RE: Automatically assign codes Use the progress token called "Process State"... titles cant be changed but represent similar headings to those you require.
Member for
19 years 4 monthsRE: Automatically assign codes
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
Member for
22 years 4 monthsRE: Automatically assign codes
Use the progress token called "Process State"... titles cant be changed but represent similar headings to those you require.