There's a lot of tips and tricks scattered all throughout this build! Which is your favourite? Check out www.SheetAnalysis.com for help building, fixing, and auditing your spreadsheets!
@emilygray98689 күн бұрын
Hey, for when you select current date, can you instead ask it to return certain drop downs?So could I chose which drop down I want and then it just return those? Thanks :)
@andreaguerri.educational4 ай бұрын
thanks so much for your simple example... but I have a problem displaying the date in the format like in your video at 28:55. To me it shows this view 44562 - 44568. What's wrong? Thank you
@michaelsglas2 ай бұрын
Select on the column where your date is and click on format. From there select Date and Time Format and select the format that best suits your needs
@louiseandersen4353Ай бұрын
How can you manually edit the date/time on start/end, when you have a formula to add the timestamp? When I try to do it, I can only edit the formula, and not the actually timestamp. Hope it makes sence. BTW I love your video.
@user-ej8st5fl9pАй бұрын
I have the same issue.. hope he'll reveal .. I'm a new fun here.
@lca85Ай бұрын
I really love this video. Thank you for doing it. However, I have a wish. It would be very useful if you could make an addition where you can register sick days, holidays, closed days and the like. I live in Denmark, and often we get the same "salary" on sick days and vacation days, but it might be good to be able to register these days anyway. With best regards Louise
@HashAliNZАй бұрын
Yes this would be an amazing addition for tracking! I'll think on it!
@Kartik.0m15 күн бұрын
I really very much appeciating your work...But.....The Start and End Time is Updating in every 5 minutes then how come it is a perfect Time Sheet.......Time is changing always...which results whole sheet with errors...please look into it
@HashAliNZ15 күн бұрын
If you followed the tutorial it shouldn't change in your sheet. The example I showed iny videos might change because I film over several hours and sometimes days and make changes as I go before cutting it down in editing.
@shaanmihaka2 ай бұрын
Where did the emojis and shit come from?
@HashAliNZ2 ай бұрын
For the in-text emojis, start typing in a cell and hold the Window Key and press the full stop (period) key. If you're a Mac, I have no clue. This opens up the emoji and symbols options. For the ones I switched out, I have no clue where they came from. Just typed into Google "Stop emoji" and "Pause emoji"