![]() 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. ![]() This 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |