Perfect! Love seeing someone who echoes my internal passion for facilities….as a retired facility manager, maintaining my home has the same importance to me.
Thank you so much Sir. These words really matter a lot to keep me pushing to create such interesting and different formats. Thank you once again for loving the video and getting connected with the Channel 😊😊😊
Hello Sir, thank you very much for your videos. May I please ask you to create something like for example Task( clean drain) drop-down ( needs to be done either daily, weekly, monthly, or quarterly) date let's say 11/02/2023 and excel will calculate the deadline depending on what has been entered - daily, weekly, monthly...) thank you kindly very much
You mean to say, you want Cleaning schedule to me managed with dropdowns? It can be done but we will have to provide criteria that in how many days you want to reschedule that specific task, weekly, monthly or quarterly
Thank you for loving the video and getting connected with the Channel 😊😊😊. I think it can be done. I will try to find out a way and will be back with you very soon
@@Cococococo-hl9lz Please download the updated file. I updated the file as per your requirement. docs.google.com/spreadsheets/d/1N5c_ZRu23_2_VhWnoLWzhPoOnpKb2KsA/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
We can but time and date will keep on changing whenever we will open the sheet. We will have to copy and paste it at values, only when the time and date will not change. +today() will give us date +now() will give us time
Amit, very soon I will come up with a new tracker in which you will get solution for your issues. Plese don't forget to check my other videos. I always try to create different formats in a simple way
Ji zarur lekin aapko Purey housing society ke logon se mera channel subscribe karwana padega. Hahahahahha. Jokes apart. I will make a note of it mam. Soon I will make a format on the same
Perfect! Love seeing someone who echoes my internal passion for facilities….as a retired facility manager, maintaining my home has the same importance to me.
Thank you so much Sir. These words really matter a lot to keep me pushing to create such interesting and different formats.
Thank you once again for loving the video and getting connected with the Channel 😊😊😊
Thank you for sharing this sir. Big help for my monitoring of my request. But can you include also how to exclude weekends and holidays?
Thank you so much for loving the video. Let me check what can be done for Weekends and Holidays. 😊😊😊
@@Office-Monk ❤
Its outstanding information
Thank you so much for loving the video and getting connected with the Channel 😊
Very good with highlighted formulas
Thank you so much for loving the video. Please subscribe the channel for such interesting videos 😊😊😊
Very nice explanation
Thank you so much for loving the video 😊
VERY USEFULL THANKU
Thank you so much for loving the video and getting connected with the Channel 😊😊😊
very helpful thanks
My pleasure 😊. Please stay connected for such useful formats
Very interresting❤❤❤❤
Thank you so much 😊😊😊
Hello Sir, thank you very much for your videos. May I please ask you to create something like for example Task( clean drain) drop-down ( needs to be done either daily, weekly, monthly, or quarterly) date let's say 11/02/2023 and excel will calculate the deadline depending on what has been entered - daily, weekly, monthly...) thank you kindly very much
You mean to say, you want Cleaning schedule to me managed with dropdowns?
It can be done but we will have to provide criteria that in how many days you want to reschedule that specific task, weekly, monthly or quarterly
is this applicable only fr excel sheets or ca be work with google sheets ttoo
You can create the same in Google Sheets
Sir, is it possible from booking sheet to show pending list in separate page
We are working indenting in textile so need to see easily pending list
Thank you for loving the video and getting connected with the Channel 😊😊😊. I think it can be done. I will try to find out a way and will be back with you very soon
@@Office-Monk ok. Waiting
@@Cococococo-hl9lz Please download the updated file. I updated the file as per your requirement.
docs.google.com/spreadsheets/d/1N5c_ZRu23_2_VhWnoLWzhPoOnpKb2KsA/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
Well noted, thank you very much,
I need some more help, pls send your WhatsApp number, if you make we will pay also
Am working in Dubai
Can we make automatic date and time at the time of entering data at discription
We can but time and date will keep on changing whenever we will open the sheet. We will have to copy and paste it at values, only when the time and date will not change.
+today() will give us date
+now() will give us time
Try this for frozen date and time:
For Date: =Ctrl + ;
For Time: = Ctrl + Shift + ;
Let me know if it works
Amit, very soon I will come up with a new tracker in which you will get solution for your issues.
Plese don't forget to check my other videos. I always try to create different formats in a simple way
@@Office-Monk I am waiting for your next vedio
Thank you Amit 😊
Can you plz teach me how to make ppm tracker
Soon
Sir housing society ki maintance ke koi sheet banye
Ji zarur lekin aapko Purey housing society ke logon se mera channel subscribe karwana padega. Hahahahahha.
Jokes apart. I will make a note of it mam. Soon I will make a format on the same
@@Office-Monk sir bilkul AAP bahot umda video banate ho
Thank you so much 😊
Why my formula doesn't show in status always false, may I have tips 😢 how can I solve this issue thanks.
Please send me the formula which you are using
@@Office-Monk =if(G6=0,","",if(I6="0",Done",If(J6="0","Pending)))
if(G6=0,"",if(I6="0",Done",If(J6="0","Pending)))
G6=0,", here you had done the mistake. After 0 you had inserted ,", and it was the issue
@@Office-Monk thank you sir.
Inglend se hai
Means ?