subject:"Slightly OT\: question about dates in Numbers app"

Re: Slightly OT: question about dates in Numbers app

2018-02-27 Thread Jonathan Cohn

Alex,

I looked at the Runners log template in Numbers thinking that perhaps it would 
have an auto-insert date function, but no luck there. There is a Insert 
Date/Time menu item that you could assign a hot key to.

Take Care,

Jonathan Cohn 
> On Feb 26, 2018, at 8:01 PM, Alex Hall  wrote:
> 
> My day job is part coder, part IT guy, so formulas don't bother me. I'm not 
> sure where to start, though, and I could only find threads about my question 
> that talked about Excel, not Numbers.
> 
> --
> Alex Hall
> 
> 
> 
> 
>> On Feb 26, 2018, at 09:00, Phil Halton > > wrote:
>> 
>> That depends, how good are you at writing spreadsheet formulas? In my 
>> experience you probably be better off just manually entering the date, such 
>> as 2/26, for February 26. It is, after all, just one more field to fill-in 
>> as opposed to some fairly tricky formula writing.
>> 
>> Sent from my IPhone
>> 
>> 
>> On Feb 25, 2018, at 8:47 PM, Alex Hall > > wrote:
>> 
>>> Hi all,
>>> This is a bit off topic, but I can't think of a better place for a Numbers 
>>> question.
>>> 
>>> On macOS, I need to keep a log for the next few weeks, updated daily. I'm 
>>> making a spreadsheet, and I'd like the first column to fill itself with the 
>>> current date whenever I enter values on the row. That is, if the first 
>>> column is the date, I want that first cell to be populated with the current 
>>> date if I enter any value in any other cell for a row. I hope this is 
>>> making sense. Can it be done? Thanks!
>>> 
>>> --
>>> Alex Hall
>>> 
>>> 
>>> 
>>> 
>>> 
>>> -- 
>>> The following information is important for all members of the Mac 
>>> Visionaries list.
>>>  
>>> If you have any questions or concerns about the running of this list, or if 
>>> you feel that a member's post is inappropriate, please contact the owners 
>>> or moderators directly rather than posting on the list itself.
>>>  
>>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
>>> mk...@ucla.edu  and your owner is Cara Quinn - you 
>>> can reach Cara at caraqu...@caraquinn.com 
>>>  
>>> The archives for this list can be searched at:
>>> http://www.mail-archive.com/macvisionaries@googlegroups.com/ 
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "MacVisionaries" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to macvisionaries+unsubscr...@googlegroups.com 
>>> .
>>> To post to this group, send email to macvisionaries@googlegroups.com 
>>> .
>>> Visit this group at https://groups.google.com/group/macvisionaries 
>>> .
>>> For more options, visit https://groups.google.com/d/optout 
>>> .
>> 
>> 
>> -- 
>> The following information is important for all members of the Mac 
>> Visionaries list.
>>  
>> If you have any questions or concerns about the running of this list, or if 
>> you feel that a member's post is inappropriate, please contact the owners or 
>> moderators directly rather than posting on the list itself.
>>  
>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
>> mk...@ucla.edu  and your owner is Cara Quinn - you 
>> can reach Cara at caraqu...@caraquinn.com 
>>  
>> The archives for this list can be searched at:
>> http://www.mail-archive.com/macvisionaries@googlegroups.com/ 
>> 
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MacVisionaries" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to macvisionaries+unsubscr...@googlegroups.com 
>> .
>> To post to this group, send email to macvisionaries@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/macvisionaries 
>> .
>> For more options, visit https://groups.google.com/d/optout 
>> .
> 
> 
> -- 
> The following information is important for all members of the Mac Visionaries 
> list.
>  
> If you have any questions or concerns about the running of this list, or if 
> you feel that a member's post is inappropriate, please contact the owners or 
> moderators directly rather than posting on the list itself.
>  
> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread Phil Halton

I learned to write formulas in the numbers app using the extensive health 
system which describes functions formulas and all the syntax they’re in. I did 
have a lot of experience in Excel spreadsheet in and he did carryover. I was 
also a programmer many moons ago and I suppose that helps a bit too. Check out 
the health system and just weighed in, it’s pretty well organized and you can 
find various formula is categorized according to their purposes. Then it’s just 
a matter of using your own creativity checking out the documentation on the 
functions and experimenting to see if it works. Like I said earlier a lot of 
work for kind of a little bit of return. But if you got the time there you go

Sent from my IPhone

> On Feb 26, 2018, at 8:44 PM, David Chittenden  wrote:
> 
> Many formuli work the same in Numbers as they do in Excel. I would try the 
> Excel instructions and see if they work for Numbers in your use case.
> 
> Kind regards,
> 
> David Chittenden, MSc, MRCAA
> Email: dchitten...@gmail.com
> Mobile: +61 488 988 936
> Sent from my iPhone
> 
>> On 27 Feb 2018, at 11:01, Alex Hall  wrote:
>> 
>> My day job is part coder, part IT guy, so formulas don't bother me. I'm not 
>> sure where to start, though, and I could only find threads about my question 
>> that talked about Excel, not Numbers.
>> 
>> --
>> Alex Hall
>> 
>> 
>> 
>> 
>>> On Feb 26, 2018, at 09:00, Phil Halton  wrote:
>>> 
>>> That depends, how good are you at writing spreadsheet formulas? In my 
>>> experience you probably be better off just manually entering the date, such 
>>> as 2/26, for February 26. It is, after all, just one more field to fill-in 
>>> as opposed to some fairly tricky formula writing.
>>> 
>>> Sent from my IPhone
>>> 
>>> 
 On Feb 25, 2018, at 8:47 PM, Alex Hall  wrote:

 Hi all,
 This is a bit off topic, but I can't think of a better place for a Numbers 
 question.

 On macOS, I need to keep a log for the next few weeks, updated daily. I'm 
 making a spreadsheet, and I'd like the first column to fill itself with 
 the current date whenever I enter values on the row. That is, if the first 
 column is the date, I want that first cell to be populated with the 
 current date if I enter any value in any other cell for a row. I hope this 
 is making sense. Can it be done? Thanks!

 --
 Alex Hall

 -- 
 The following information is important for all members of the Mac 
 Visionaries list.

 If you have any questions or concerns about the running of this list, or 
 if you feel that a member's post is inappropriate, please contact the 
 owners or moderators directly rather than posting on the list itself.

 Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
 mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
 caraqu...@caraquinn.com

 The archives for this list can be searched at:
 http://www.mail-archive.com/macvisionaries@googlegroups.com/
 --- 
 You received this message because you are subscribed to the Google Groups 
 "MacVisionaries" group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to macvisionaries+unsubscr...@googlegroups.com.
 To post to this group, send email to macvisionaries@googlegroups.com.
 Visit this group at https://groups.google.com/group/macvisionaries.
 For more options, visit https://groups.google.com/d/optout.
>>> 
>>> 
>>> -- 
>>> The following information is important for all members of the Mac 
>>> Visionaries list.
>>>  
>>> If you have any questions or concerns about the running of this list, or if 
>>> you feel that a member's post is inappropriate, please contact the owners 
>>> or moderators directly rather than posting on the list itself.
>>>  
>>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
>>> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
>>> caraqu...@caraquinn.com
>>>  
>>> The archives for this list can be searched at:
>>> http://www.mail-archive.com/macvisionaries@googlegroups.com/
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "MacVisionaries" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to macvisionaries+unsubscr...@googlegroups.com.
>>> To post to this group, send email to macvisionaries@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/macvisionaries.
>>> For more options, visit https://groups.google.com/d/optout.
>> 
>> -- 
>> The following information is important for all members of the Mac 
>> Visionaries list.
>>  
>> If you have any questions or concerns about the running of this list, or if 
>> you feel that a member's post is inappropriate, please

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread David Chittenden

Many formuli work the same in Numbers as they do in Excel. I would try the 
Excel instructions and see if they work for Numbers in your use case.

Kind regards,

David Chittenden, MSc, MRCAA
Email: dchitten...@gmail.com
Mobile: +61 488 988 936
Sent from my iPhone

> On 27 Feb 2018, at 11:01, Alex Hall  wrote:
> 
> My day job is part coder, part IT guy, so formulas don't bother me. I'm not 
> sure where to start, though, and I could only find threads about my question 
> that talked about Excel, not Numbers.
> 
> --
> Alex Hall
> 
> 
> 
> 
>> On Feb 26, 2018, at 09:00, Phil Halton  wrote:
>> 
>> That depends, how good are you at writing spreadsheet formulas? In my 
>> experience you probably be better off just manually entering the date, such 
>> as 2/26, for February 26. It is, after all, just one more field to fill-in 
>> as opposed to some fairly tricky formula writing.
>> 
>> Sent from my IPhone
>> 
>> 
>>> On Feb 25, 2018, at 8:47 PM, Alex Hall  wrote:
>>> 
>>> Hi all,
>>> This is a bit off topic, but I can't think of a better place for a Numbers 
>>> question.
>>> 
>>> On macOS, I need to keep a log for the next few weeks, updated daily. I'm 
>>> making a spreadsheet, and I'd like the first column to fill itself with the 
>>> current date whenever I enter values on the row. That is, if the first 
>>> column is the date, I want that first cell to be populated with the current 
>>> date if I enter any value in any other cell for a row. I hope this is 
>>> making sense. Can it be done? Thanks!
>>> 
>>> --
>>> Alex Hall
>>> 
>>> 
>>> 
>>> 
>>> 
>>> -- 
>>> The following information is important for all members of the Mac 
>>> Visionaries list.
>>>  
>>> If you have any questions or concerns about the running of this list, or if 
>>> you feel that a member's post is inappropriate, please contact the owners 
>>> or moderators directly rather than posting on the list itself.
>>>  
>>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
>>> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
>>> caraqu...@caraquinn.com
>>>  
>>> The archives for this list can be searched at:
>>> http://www.mail-archive.com/macvisionaries@googlegroups.com/
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "MacVisionaries" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to macvisionaries+unsubscr...@googlegroups.com.
>>> To post to this group, send email to macvisionaries@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/macvisionaries.
>>> For more options, visit https://groups.google.com/d/optout.
>> 
>> 
>> -- 
>> The following information is important for all members of the Mac 
>> Visionaries list.
>>  
>> If you have any questions or concerns about the running of this list, or if 
>> you feel that a member's post is inappropriate, please contact the owners or 
>> moderators directly rather than posting on the list itself.
>>  
>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
>> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
>> caraqu...@caraquinn.com
>>  
>> The archives for this list can be searched at:
>> http://www.mail-archive.com/macvisionaries@googlegroups.com/
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MacVisionaries" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to macvisionaries+unsubscr...@googlegroups.com.
>> To post to this group, send email to macvisionaries@googlegroups.com.
>> Visit this group at https://groups.google.com/group/macvisionaries.
>> For more options, visit https://groups.google.com/d/optout.
> 
> -- 
> The following information is important for all members of the Mac Visionaries 
> list.
>  
> If you have any questions or concerns about the running of this list, or if 
> you feel that a member's post is inappropriate, please contact the owners or 
> moderators directly rather than posting on the list itself.
>  
> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
> caraqu...@caraquinn.com
>  
> The archives for this list can be searched at:
> http://www.mail-archive.com/macvisionaries@googlegroups.com/
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MacVisionaries" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to macvisionaries+unsubscr...@googlegroups.com.
> To post to this group, send email to macvisionaries@googlegroups.com.
> Visit this group at https://groups.google.com/group/macvisionaries.
> For more options, visit https://groups.google.com/d/optout.

-- 
The following information is important for all members of the Mac Visionaries 
list.

If you have

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread Alex Hall

My day job is part coder, part IT guy, so formulas don't bother me. I'm not 
sure where to start, though, and I could only find threads about my question 
that talked about Excel, not Numbers.

--
Alex Hall




> On Feb 26, 2018, at 09:00, Phil Halton  wrote:
> 
> That depends, how good are you at writing spreadsheet formulas? In my 
> experience you probably be better off just manually entering the date, such 
> as 2/26, for February 26. It is, after all, just one more field to fill-in as 
> opposed to some fairly tricky formula writing.
> 
> Sent from my IPhone
> 
> 
> On Feb 25, 2018, at 8:47 PM, Alex Hall  > wrote:
> 
>> Hi all,
>> This is a bit off topic, but I can't think of a better place for a Numbers 
>> question.
>> 
>> On macOS, I need to keep a log for the next few weeks, updated daily. I'm 
>> making a spreadsheet, and I'd like the first column to fill itself with the 
>> current date whenever I enter values on the row. That is, if the first 
>> column is the date, I want that first cell to be populated with the current 
>> date if I enter any value in any other cell for a row. I hope this is making 
>> sense. Can it be done? Thanks!
>> 
>> --
>> Alex Hall
>> 
>> 
>> 
>> 
>> 
>> -- 
>> The following information is important for all members of the Mac 
>> Visionaries list.
>>  
>> If you have any questions or concerns about the running of this list, or if 
>> you feel that a member's post is inappropriate, please contact the owners or 
>> moderators directly rather than posting on the list itself.
>>  
>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
>> mk...@ucla.edu  and your owner is Cara Quinn - you 
>> can reach Cara at caraqu...@caraquinn.com 
>>  
>> The archives for this list can be searched at:
>> http://www.mail-archive.com/macvisionaries@googlegroups.com/ 
>> 
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MacVisionaries" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to macvisionaries+unsubscr...@googlegroups.com 
>> .
>> To post to this group, send email to macvisionaries@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/macvisionaries 
>> .
>> For more options, visit https://groups.google.com/d/optout 
>> .
> 
> 
> -- 
> The following information is important for all members of the Mac Visionaries 
> list.
>  
> If you have any questions or concerns about the running of this list, or if 
> you feel that a member's post is inappropriate, please contact the owners or 
> moderators directly rather than posting on the list itself.
>  
> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
> caraqu...@caraquinn.com
>  
> The archives for this list can be searched at:
> http://www.mail-archive.com/macvisionaries@googlegroups.com/ 
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MacVisionaries" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to macvisionaries+unsubscr...@googlegroups.com 
> .
> To post to this group, send email to macvisionaries@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/macvisionaries 
> .
> For more options, visit https://groups.google.com/d/optout 
> .

-- 
The following information is important for all members of the Mac Visionaries 
list.

If you have any questions or concerns about the running of this list, or if you 
feel that a member's post is inappropriate, please contact the owners or 
moderators directly rather than posting on the list itself.

Your Mac Visionaries list moderator is Mark Taylor.  You can reach mark at:  
mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
caraqu...@caraquinn.com

The archives for this list can be searched at:
http://www.mail-archive.com/macvisionaries@googlegroups.com/
--- 
You received this message because you are subscribed to the Google Groups 
"MacVisionaries" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to macvisionaries+unsubscr...@googlegroups.com.
To post to this group, send email to macvisionaries@googlegroups.com.
Visit this group at https://groups.google.com/group/macvisionaries.
For more options, visit

Re: Slightly OT: question about dates in Numbers app

2018-02-26 Thread Phil Halton

That depends, how good are you at writing spreadsheet formulas? In my 
experience you probably be better off just manually entering the date, such as 
2/26, for February 26. It is, after all, just one more field to fill-in as 
opposed to some fairly tricky formula writing.

Sent from my IPhone


> On Feb 25, 2018, at 8:47 PM, Alex Hall  wrote:
> 
> Hi all,
> This is a bit off topic, but I can't think of a better place for a Numbers 
> question.
> 
> On macOS, I need to keep a log for the next few weeks, updated daily. I'm 
> making a spreadsheet, and I'd like the first column to fill itself with the 
> current date whenever I enter values on the row. That is, if the first column 
> is the date, I want that first cell to be populated with the current date if 
> I enter any value in any other cell for a row. I hope this is making sense. 
> Can it be done? Thanks!
> 
> --
> Alex Hall
> 
> 
> 
> 
> -- 
> The following information is important for all members of the Mac Visionaries 
> list.
>  
> If you have any questions or concerns about the running of this list, or if 
> you feel that a member's post is inappropriate, please contact the owners or 
> moderators directly rather than posting on the list itself.
>  
> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: 
> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
> caraqu...@caraquinn.com
>  
> The archives for this list can be searched at:
> http://www.mail-archive.com/macvisionaries@googlegroups.com/
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MacVisionaries" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to macvisionaries+unsubscr...@googlegroups.com.
> To post to this group, send email to macvisionaries@googlegroups.com.
> Visit this group at https://groups.google.com/group/macvisionaries.
> For more options, visit https://groups.google.com/d/optout.

-- 
The following information is important for all members of the Mac Visionaries 
list.

If you have any questions or concerns about the running of this list, or if you 
feel that a member's post is inappropriate, please contact the owners or 
moderators directly rather than posting on the list itself.

Your Mac Visionaries list moderator is Mark Taylor.  You can reach mark at:  
mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
caraqu...@caraquinn.com

The archives for this list can be searched at:
http://www.mail-archive.com/macvisionaries@googlegroups.com/
--- 
You received this message because you are subscribed to the Google Groups 
"MacVisionaries" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to macvisionaries+unsubscr...@googlegroups.com.
To post to this group, send email to macvisionaries@googlegroups.com.
Visit this group at https://groups.google.com/group/macvisionaries.
For more options, visit https://groups.google.com/d/optout.

Slightly OT: question about dates in Numbers app

2018-02-25 Thread Alex Hall

Hi all,
This is a bit off topic, but I can't think of a better place for a Numbers 
question.

On macOS, I need to keep a log for the next few weeks, updated daily. I'm 
making a spreadsheet, and I'd like the first column to fill itself with the 
current date whenever I enter values on the row. That is, if the first column 
is the date, I want that first cell to be populated with the current date if I 
enter any value in any other cell for a row. I hope this is making sense. Can 
it be done? Thanks!

--
Alex Hall




-- 
The following information is important for all members of the Mac Visionaries 
list.

If you have any questions or concerns about the running of this list, or if you 
feel that a member's post is inappropriate, please contact the owners or 
moderators directly rather than posting on the list itself.

Your Mac Visionaries list moderator is Mark Taylor.  You can reach mark at:  
mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at 
caraqu...@caraquinn.com

The archives for this list can be searched at:
http://www.mail-archive.com/macvisionaries@googlegroups.com/
--- 
You received this message because you are subscribed to the Google Groups 
"MacVisionaries" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to macvisionaries+unsubscr...@googlegroups.com.
To post to this group, send email to macvisionaries@googlegroups.com.
Visit this group at https://groups.google.com/group/macvisionaries.
For more options, visit https://groups.google.com/d/optout.

Re: Slightly OT: question about dates in Numbers app

Re: Slightly OT: question about dates in Numbers app

Re: Slightly OT: question about dates in Numbers app

Re: Slightly OT: question about dates in Numbers app

Re: Slightly OT: question about dates in Numbers app

Slightly OT: question about dates in Numbers app

6 matches

Site Navigation

Mail list logo

Footer information