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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics