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 "T...
  • OliverScheurich's avatar
    Nov 10, 2022

    Ri_De370 

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

    The formula works as intended in my sheet.

     

Resources