Nov 10 2022 12:51 AM
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
Nov 10 2022 01:19 AM
SolutionNov 10 2022 01:32 AM - edited Nov 10 2022 01:35 AM
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!
Nov 10 2022 01:19 AM
Solution=IF(B1<>"", IF(A1<>"",B1,NOW()),"")
The formula works as intended in my sheet.