Forum Discussion

JoachimD's avatar
JoachimD
Copper Contributor
Jul 23, 2021

Problem with calculated column in Lists

Hi,

 

I'm having a bit of a struggle getting a calculated column doing what I want.

So here's the issue;

I have 6 columns

Column1, column2 and column3 have timestamps in them

Column4 and column5 can have a value or be empty

Column6 is a calculated one

For now column6 has following formula to show the minutes between the 2 timestaps

=([Column2]-Column1)*1440

This is working fine.

But now I'm looking for a solution that, in case there's a value in column4, column6 just needs to show (copy over) the value that's in column4 and not do the calculation anymore.

 

Thanks in advance

No RepliesBe the first to reply

Resources