Numbers - Autofill Date when entering data?

Discussion in 'iPad Apps' started by electronique, Aug 17, 2011.

  1. electronique macrumors 6502

    Joined:
    Aug 27, 2008
    #1
    Hi.. Simple Numbers questions.

    If I have a simple form, with Column A being Date, Column B being Subject and C being description..

    I want column A to be Auto-filled with todays date, when I am entering data into column B..

    Any ideas how I do this?
     
  2. Ashwood11 macrumors 65816

    Joined:
    Nov 10, 2010
    Location:
    US
  3. electronique thread starter macrumors 6502

    Joined:
    Aug 27, 2008
    #3
    A bit more info here.. Not sure what, where, how you mean?
     
  4. jaseone macrumors 65816

    jaseone

    Joined:
    Nov 7, 2004
    Location:
    Houston, USA
    #4
    I finally bit the bullet and bought Numbers just so I could answer this...

    For some reason I can't paste the formula Itself from Numbers but basically in the cell you want the date start a formula with =, then choose If, then isblank, then touch the cell that would have the subject, then for true go to the ABC keyboard, hit done to give it a blank value and then for false use the today formula. Then save by touching the tick mark, then touch the cell so it has the options come up, press Fill and then drag the handle down the column as far down as you want.
     
  5. Ashwood11 macrumors 65816

    Joined:
    Nov 10, 2010
    Location:
    US
    #5
    Go to the menu bar at the top of the window and select the "Tools" icon. The 4th item on the scroll down list is "Help".
     
  6. electronique thread starter macrumors 6502

    Joined:
    Aug 27, 2008
    #6
    Brilliant... Absolutely brilliant.
    Thanks a heap..

    I've actually never work with formulas in spreadsheets before.. This has given me a taste of what's possible.. Thanks again

    Now to find out how to add that formula to each new row I add, when needed.
     
  7. Ashwood11 macrumors 65816

    Joined:
    Nov 10, 2010
    Location:
    US
    #7
    Check "Help", it will tell you how to add the formula to each new row.
     
  8. jaseone macrumors 65816

    jaseone

    Joined:
    Nov 7, 2004
    Location:
    Houston, USA
    #8
    That was the latter part of my instructions. ;)
     
  9. KostasProb macrumors newbie

    Joined:
    Feb 15, 2015
    #9
    Jaseone

    Thanks for your reply this was my question too. Nonetheless I realized that each time I add a new record to the form, all dates (including those of previous records) change to today's date.

    My question is: is it possible to keep the date/time that was automatically entered when the data was filled in, to remain stable for each separate entry and not change (in other words I need it to appear on the spreadsheet table as the exact time that the data on this particular row were entered and stay there as a permanent "proof" of the exact time that this particular entry occurred.

    Is it possible?

    I notice that this is a very old discussion, I hope everyone is ok and someone can reply

    Thanks to all!
     
  10. notrack macrumors 6502

    Joined:
    Feb 19, 2012
    #10
    I would also much apreciate such a feature. A kind of time stamp or date picker or so. However, afaik, there isn't such thing. I filed a feature request a while ago but I have little hope that it will actually come alive.
     
  11. GerritV, Feb 20, 2015
    Last edited: Feb 20, 2015

    GerritV macrumors 65816

    GerritV

    Joined:
    May 11, 2012
    #11
    Actually you can try something, I just don't have the English version of Numbers at hand.
    One of the formula's in the Text category should be called something like PLAIN.TEXT.
    Your formula in column A should then read:

    IF(B1>"";PLAIN.TEXT(TODAY);"")

    TODAY returning a number (right aligned by default), PLAIN.TEXT returns a text (left aligned by default).
    This should be an indication for you to see it's working.

    As for the other part of the problem: in Numbers, you can't make a formula automatically pop up in an empty A cell once there is a content in a B cell next to it. This is however doable in Excel via VisualBasic. So you should take Jaseone's latter part and copy the formula in the A column downward.

    Indeed, very sad to see how little progress is made in Numbers during the past 4 years...


    EDIT: sorry, my idea doesn't work either.
     

Share This Page