How to know what a data type returns a "field type" in formula?

T

TomyBerlin

Where can I find the data type that returns a "field type" in a formula?
I´m trying to customize a Custom Field with a formula like for example:
IIf([Estado]="Completada";1;0) where can I find th data type or possible
results for "Estado" (Estado means State in spanish, it returns Completed,
Not finished or On schedule, and it is a String, but i´m not sure about this)

Please help me, i need a answer as soon as posible.
Thanks
Saludos de Chile
 
D

Dale Howard [MVP]

TomyBerlin --

Are you referring to the Status field? When you insert the Status field in
any Task View, the field displays one of the following values for every task
in the project, relative to the Status Date you specify in the project:

Complete
On Schedule
Late
Future Task

The Status Field is actually a calculated number field, and uses the
following numbers to repesent the status of each task:

0 = Complete
1 = On Schedule
2 = Late
3 = Future Task

Let us know if this is what you are looking for. Hope this helps.
 
T

TomyBerlin

Thanks, it was and is very helpful.
But I need to know where can I find a list with all the data types, and not
only the Status Field.

However I´m very glad you wrote this post, it will help me a lot.+
Thanks

Dale Howard said:
TomyBerlin --

Are you referring to the Status field? When you insert the Status field in
any Task View, the field displays one of the following values for every task
in the project, relative to the Status Date you specify in the project:

Complete
On Schedule
Late
Future Task

The Status Field is actually a calculated number field, and uses the
following numbers to repesent the status of each task:

0 = Complete
1 = On Schedule
2 = Late
3 = Future Task

Let us know if this is what you are looking for. Hope this helps.




TomyBerlin said:
Where can I find the data type that returns a "field type" in a formula?
I´m trying to customize a Custom Field with a formula like for example:
IIf([Estado]="Completada";1;0) where can I find th data type or possible
results for "Estado" (Estado means State in spanish, it returns Completed,
Not finished or On schedule, and it is a String, but i´m not sure about
this)

Please help me, i need a answer as soon as posible.
Thanks
Saludos de Chile
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top