CODEWITHSUNDEEP
if-statementcheckboxgoogle-sheetssumgoogle-sheets-formula
mKeey
mKeey

Reputation: 135

Google Sheets WENN Date and Checkbox

i'm trying to figure out, how I can get my formula working. It's telling me I need a valid date.

So if i'm going for this :

J3=checkbox, D5=date formated with =today(), G5=number between 1-30

=WENN(J3=FALSE;D5+G5) This works fine ( today() + 1-30 )

Now here comes the error :

=WENN(J3=FALSE;D5+G5;);WENN(J3=TRUE;D5+7;) This does not work because now it's telling me I need the valid date.

So my question is, how I can get it work?

Upvotes: 1

Views: 62

Answers (1)

player0
player0

Reputation: 1

try like this:

=IF(D3=FALSE; A3+C3; A3+7)

for arrayformula use:

=ARRAYFORMULA(IF(A3:A="";;IF(D3:D=FALSE; A3:A+C3:C; A3:A+7))

enter image description here

Upvotes: 1

Related Questions