![]() The ideal solution that I would love would be to have something as simple as what Google sheets has, there is a kestroke for (static) date and a variation of that keystroke for (static) date and time it is super easy. Q: Anyone aware of a tool that will input static date and time with a keystroke (into a single cell)?įYI I did input a suggestion in the Apple feedback site but considering there are forums on this with hundreds of pages of comments going back to at least 2014 and maybe earlier and it still is not available, I'm not sure if my feedback will be seen or make a difference. Any insight?)Ĥ) Third party tools such as "Typinator" This is one of perhaps many utilities out there that can automate typing functions in a thread someone had said they used it to input current date and time but on the website for the utility I could not find any info on it being able to input static date and time for Apple Numbers, but perhaps it or another third party tool can work. I looked in my keyboard settings under the 'shortcuts' tab and I could not see that cmd semi-colon was assigned to anything. Also can anyone confirm if it will remain static so that it will NOT auto update? (bonus question: Barry had said that cmd semi-colon was a shortcut when I do that instead of the date & time being inserted my cursor jumps to a different page in the Numbers spreadsheet. Is there a way to automate these steps or to assign a single keystroke that will do both steps? It is good that this method works, but I can not see myself using it in its current form considering I may have to do it over a hundred times each day it would need to be somehow more efficient in order to be worth it. #Typinator unsert time updateThis works but it takes so many steps! I don't know if it will remain static or if it will update like the =Now method. Q: If a user does only the first step the time defaults to midnight the user needs to then go outside the cell & go back in to double click again as per Barry's post to choose a date and time format which will then put the current time. This will then give the current date & time in a static form. ![]() Q: I was not able to follow the instructions in other posts on this as they were spread across several back-and-forth discussions, if you know how this works could you type out the steps from start to finish, including various permissions that need to be granted?īarry (forum mod) posted this option: 1) double click in the cell, 2) insert menu > date & time (or press cmd semi-colon), then once done, go outside the cell, then back to it again and double click and a drop-down menu will appear, in that menu choose from the selection list of a variety of date & time options. “System Events got an error: Automator Workflow Runner (WorkflowServiceRunner, Today) is not allowed to send keystrokes.” A solution was offered to such errors but I could not figure it out on my system. Is there some derivative of this formula that will not auto update the date and time? Q: By default it will auto update it would be such an easy solution if there was a formula for current date and time that would NOT auto update. And if it is frequently used a smart tip is to leave the "=Now" in a dedicated cell so it is always available to be copied and then pasted (value only). Then to get the value from it without auto update, copy (cmd C) and then paste the value without the formatting (cmd shift V). Here are the workarounds I have found with my questions: I need to input the date and time often hundreds of times daily so a quick keystroke would be gold for me. ![]() ![]() The workarounds I have found can get the job done but are either confusing to set up or they require so many keystrokes that it's inefficient. It seems there is yet to be a simple method to input date & time in a single cell that is static (will not auto update when the file is opened later). ![]() I just read a pile of threads on this topic going back to 2014, as well as in non-Apple forums. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |