Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
2 years ago
Solved

Custom Column Formula Help

I have the following formula for a custom column.     It works except when Time Started or Time Injured is null and then my column returns an error   if([Time Started]>[Time Injured]) then [Time ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    bdehning 

    pls try this

    if [Time Started] is null or [Time Injured] is null then null else if [Time Started]>[Time Injured] then [Time Injured]-[Time Started]+1 else [Time Injured]-[Time Started]

     

bdehning's avatar
bdehning
Post Prodigy
2 years ago

 if([Time Started]>[Time Injured]) then [Time Injured]-[Time Started]+1 else [Time Injured]-[Time Started]  

 

How do I add "if  time injured is null or time started is null then null" to what I already have?

 

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

bdehning 

pls try this

if [Time Started] is null or [Time Injured] is null then null else if [Time Started]>[Time Injured] then [Time Injured]-[Time Started]+1 else [Time Injured]-[Time Started]