SOLVED

Need help with an autofill formula

Copper Contributor

Hello

 

I'm trying to create a row that autofills todays date when I plot data into a different row. The formula I have found (an example of it) is =IF(B1<>"", IF(A1<>"",B1,NOW()),"")
I get the "There's a problem with this formula" -error whenever i try it out, but I have no idea whats wrong here. 

Thanks in advance 

2 Replies
best response confirmed by Ri_De370 (Copper Contributor)
Solution

@Ri_De370 

=IF(B1<>"", IF(A1<>"",B1,NOW()),"")

The formula works as intended in my sheet.

now.JPG 

@OliverScheurich 

 

Thats odd, it absolutely downs't work for me. Tried using my own language too, no difference. Its highlighting this part: "", 

EDIT: it was the semicolons. Duh. Thanks so much! 

 

 

1 best response

Accepted Solutions
best response confirmed by Ri_De370 (Copper Contributor)
Solution

@Ri_De370 

=IF(B1<>"", IF(A1<>"",B1,NOW()),"")

The formula works as intended in my sheet.

now.JPG 

View solution in original post