Forum Discussion

Ri_De370's avatar
Ri_De370
Copper Contributor
Nov 10, 2022
Solved

Need help with an autofill formula

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 

excel
Formulas and Functions

2 Replies

    • Ri_De370's avatar
      Ri_De370
      Copper Contributor
      Nov 10, 2022

      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! 

       

       

Resources