can custom fields display percentages

M

monstadunk

can I add a custom unit type to a custom field? For example;
As I said, we deal a lot with inches and feet. Can I create a custom field
that I can enter information to and have it display # inches? And what about
percentages? I have not been able to make a custom field display percentages.
I would be able to save myself some time if I could create a custom % field
that would take the Number 3 category and add it to % Complete. I imagine it
would look something like this;

([% Complete] + [Numer 3])%

I tried this, but it didn't work.
 
J

John

monstadunk said:
can I add a custom unit type to a custom field? For example;
As I said, we deal a lot with inches and feet. Can I create a custom field
that I can enter information to and have it display # inches? And what about
percentages? I have not been able to make a custom field display percentages.
I would be able to save myself some time if I could create a custom % field
that would take the Number 3 category and add it to % Complete. I imagine it
would look something like this;

([% Complete] + [Numer 3])%

I tried this, but it didn't work.

monstadunk,
The only spare fields that can be totally customized (i.e. units) are
the spare text fields. Here's what I suggest you do. Designate a spare
number field for entry of your inches value and another for entry of
your percentages. Then in a couple of spare text fields, customize them
with a formula to take the entry field and append the appropriate units.

For example, use the Number1 field for entry of the inches value.
Customize the Text1 field as follows:
Text1=[Number1] & " in"

Hope this helps.
John
Project MVP
 

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