Hi
So Ive integrated a form with Google sheets
sheet 1 has the list of names
sheet 2 has the form responses sample shown below
I
I would like to be able to calculate the difference between today's date and the date in column U of sheet 2
if the name in Column B and C on sheet 2 matches
the name in column b and C on sheet 1
Can anyone help. I keep making a mistake somewhere
heres the formula i tried to use
=IF('sheet 2'!C2="test",TODAY()-'sheet 2'!B2)
So Ive integrated a form with Google sheets
sheet 1 has the list of names
sheet 2 has the form responses sample shown below
I
I would like to be able to calculate the difference between today's date and the date in column U of sheet 2
if the name in Column B and C on sheet 2 matches
the name in column b and C on sheet 1
Can anyone help. I keep making a mistake somewhere
heres the formula i tried to use
=IF('sheet 2'!C2="test",TODAY()-'sheet 2'!B2)