How to hide error value in column
SharePoint 2007:
I have a list with 1 calculate column name "Time Taken To Approved",
this column actually calculate from date field
"Document Approved" - "Document Created"
But some of the return value is show as #NUM!, this is because
"Document Approved" when workflow started is a blank field.
Below is my formula for column "Time Taken To Approved"
=DATEDIF(CreatorDT,ApproverDT-(MOD(CreatorDT,1)>MOD(ApproverDT,1)),"d")&" days, "&TEXT(MOD(ApproverDT-CreatorDT,1),"hh "" hrs, "" mm "" mins""")
So how can i hide #NUM! from appear OR change it to different name like
"NA",
Please assists, thanks in advance.
April 14th, 2011 4:30am
Hi Mr.Cosmic,
here is the solution for your request :
=IF(ISERROR(DATEDIF(CreatorDT,ApproverDT-(MOD(CreatorDT,1)>MOD(ApproverDT,1)),"d")&" days"),"NA",DATEDIF(CreatorDT,ApproverDT-(MOD(CreatorDT,1)>MOD(ApproverDT,1)),"d")&" days, "&TEXT(MOD(ApproverDT-CreatorDT,1),"hh "" hrs, "" mm "" mins"""))
if anything you want feel free to ask
regards,
Venkat. K
Moderator Note: NEVER propose your own posts as answers. The "Propose as Answer" function is for people to propose the good answers of
other people. It is NOT for self-proposing.
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 10:55pm