Forum Discussion

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
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]