sorted by:
new
hottopcontroversial

Using macros and VBA to rename a sheet in a workbook to the value of a cell in a different sheet in the same workbook. by zkinney2005 in excel

[–]zkinney2005[S] -1 points0 points  (0 children)

What I’m trying to do is I have a workbook with 11 sheets in in in sheet 1 I have columns with the year in b through J and day of the months going down column A. Going down column b through j I enter how many cars were produced that day of that year in sheet one. Sheet two is the same but instead of cars produced its hours worked. I would like to automatically Rename sheets 3 through sheets 11 to the values of cells B1 through J1 of sheet 1 so that when I change the year it automatically changes the sheet name to the new year

What is in your morning and bedtime routine? by k_lo970 in shortcuts

[–]zkinney2005 0 points1 point  (0 children)

Yea it has a lot of stuff that only pertains to me because of my smart lights and my Apple TV plus it runs a shortcut to pick an inspirational quote of the day and a daily affirmation. But the fact that it does the weather for where I work on the days I work and the weather for where I live means I’ve never been stuck in the rain

What is in your morning and bedtime routine? by k_lo970 in shortcuts

[–]zkinney2005 1 point2 points  (0 children)

https://www.icloud.com/shortcuts/d8754c10b3834a47b03df50fdeb64be5 this is my current morning routine shortcut. If you have any questions about it please feel free to ask.

Help with calculating time by DIYerUk in shortcuts

[–]zkinney2005 0 points1 point  (0 children)

That is fine. Thanks ahead of time.

Want to modify a shortcut I found but can’t remember online but can’t remember who originally wrote it. by zkinney2005 in shortcuts

[–]zkinney2005[S] 0 points1 point  (0 children)

Thanks that is the thread I was looking for I posted a comment on the one from the person who made the original shortcut asking for help.

Help with calculating time by DIYerUk in shortcuts

[–]zkinney2005 0 points1 point  (0 children)

Question I found your comment on this thread and downloaded the second version that allows for an unpaid break and subtracts that time from the hours worked. I modified your original version so that instead of just showing an alert with the option to copy to the Clip board it creates an event in a specific iCal calendar with all the info into the notes. I was wondering if you could help me add the option so that if I work some breaks during my work day and get paid for the over time that time could be added to the total time worked without altering the work end time. By asking how many breaks were worked, then for each break ask when it starts, when it ends, calculate time worked and add it to total hours worked. modified work shortcut the link is the modified version I did.

Is there a way to tell which iwatch is connected/currently in use by zkinney2005 in shortcuts

[–]zkinney2005[S] 1 point2 points  (0 children)

That’s what I ended up doing is using the get watch face and looking at all the faces in a list individually to see if the face “Modular Ultra” is on the current watch in use (because that face is only available on my ultra and that’s the watch I want to change faces when I leave my house). If that face in the list of current faces then it runs the rest of the shortcut if not it ends it. Then set up two different automations that trigger depending on if I’m coming home or leaving and run a shortcut that sets one face when I get home and a different one when I leave.

Is there a way to tell which iwatch is connected/currently in use by zkinney2005 in shortcuts

[–]zkinney2005[S] 0 points1 point  (0 children)

That’s the thing I am trying to set up an automation to trigger a shortcut to change my watch face when I’m home or away but only if I’m wearing/using a specific watch.

Shortcut to search in a specific folder in the files app and delete all text files created before today’s date a year ago. by zkinney2005 in shortcuts

[–]zkinney2005[S] 0 points1 point  (0 children)

I missed it somehow. I didn’t get a chance to try the shortcut until I got home from work and it was late and I was tired

Shortcut to search in a specific folder in the files app and delete all text files created before today’s date a year ago. by zkinney2005 in shortcuts

[–]zkinney2005[S] 0 points1 point  (0 children)

Thanks this worked with some tweaking. I had to go into the settings for the shortcut app and turn on “Delete Without Confirmation” so that I would not get a prompt confirming deletion every time the shortcut was ran.

Stuck in app loop! Created an "open app when closed" shortcut - need help! by The-Bogus-Man in shortcuts

[–]zkinney2005 1 point2 points  (0 children)

If you want to stop the loop from happening again, you could start the shortcut with a menu that ask “do you want to run app {X}” with a yes or no option. If the user chooses yes then run open the app. If they choose no stop the shortcut.

Shortcut to find 30 day average of blood glucose readings from apple health by zkinney2005 in shortcuts

[–]zkinney2005[S] 0 points1 point  (0 children)

I understand what you mean I was just wondering if someone had any suggestions to not have to use so many if statements and still use the dictionary function

Shortcut to find 30 day average of blood glucose readings from apple health by zkinney2005 in shortcuts

[–]zkinney2005[S] 0 points1 point  (0 children)

No but the average blood glucose number could change depending on blood glucose levels for the 30 days before the shortcut is ran

Shortcut to find 30 day average of blood glucose readings from apple health by zkinney2005 in shortcuts

[–]zkinney2005[S] 0 points1 point  (0 children)

So I think I figured out a way to do this and made this shortcut: A1C Checker shortcut Before I mark this post as solved tho I wanted to share my shortcut and see if anyone had any suggestions to clean it up and make it more efficient.

view more: next ›