Collaborate on Bill in Excel for Facilities with Ease Using airSlate SignNow

Bill in excel for Facilities

A Maintenance Checklist is a document in which  we track all the maintenance related issues,   so that it can be reviewed on timely  basis and appropriate action can be   taken. In today's video we will see how to  make a maintenance or a complaint sheet.   The sheet will be fully automated and we  will have to update hardly something in   this sheet. We are going to track when the  complaint was raised,. when it was resolved   and how many days it took to be resolved.  Is the work done or still pending ? What   was the nature of the complaint ? We are going  to track every small thing in this technology.   Let's start the video without any delays. This  is a Complaint or Maintenance follow-up log which   I have already created in advance. There are few  things like issues means you'll have to highlight   or type or mention all your issues over here store  code ticket number if your issues get registered   in system you can mention ticket number over  here or you can leave it Priority low high medium   urgent so priorities will be managed by drop downs  and it will be automatically colored information   date whenever issues or complaint comes you  will have to mention information date over here   and whenever the issues get resolved you will  have to mention completion date over here rest   of the things will be managed by formulas if I'll  remove completion date from here you will see that   pending from days is showing and time taken in  completion is showing zero and Status it's pending   and comments its take follow-up as soon as I'll be  putting completion date over here all the things   will be changed so I'll put completion date over  here and you will notice that the days which were   in pending from its shifted to time taken in  completion status became done and it got green   and comment became needs more Focus so let's  start creating a new sheet one thing more over   here the department will be managed by drop  downs let's start creating a new sheet fourth   thing is priority so we will create drop down for  priority we will be going to data then we will be   going to data validation we will be going to  drop down and we will be selecting the list   in Source we will type urgent high medium low  and we will do okay we will drag this till down   and our drop down is created now we will highlight  this to highlight this we will have to go in home   then conditional formatting highlight cell rule  text that contains and over here we will type   urgent we will keep urgent as red so we will do  it okay again we will be going to conditional   formatting highlight cell rule text that contains  this time we are going to take High we will put   high as red color so we will do it okay again  conditional formatting highlight cell rule text   that contains this time we will put medium and  we will select yellow color will do okay again we   will be going to conditional formatting highlight  cell rule text that contains and this time we will   take low we will select green color over here and  we will do okay now we will drag this still down   urgent high medium and low so our drop downs  as well as color format is working very well   information date we will take information date  from Back sheet and we will paste it over there   now we will be calculating the formula of pending  from and the formula will be plus or equal to if   bracket open completion date is greater than 0  comma double inverted comma 0 double inverted   comma close comma if bracket open information  date is equal to 0 comma double inverted comma   0 double inverted comma close comma today bracket  open traffic flows minus information date and we   will close the bracket till our bracket doesn't  get black we will do enter now we will drag this   till end time taken in completion will be  inserting the formula and the formula of   limit Plus or equal to if bracket open completion  date is equal to 0 comma double inverted comma 0   double inverted comma close comma completion date  minus information date bracket close and we will   do enter we will drag this till end currently  it's showing 0 because we haven't put anything   in completion date we will take completion date  from back side will paste it over here one thing   you will notice that the day is which we are  showing in pending from it directly shifted to   time taken in completion I'll remove this once  it shifted to pending from days I'll paste it   once again and the days shifted to time taken in  completion now we will be coming to status and   the formula will be plus or equal to if bracket  open information date is equal to 0 comma double   inverted comma two times comma if bracket open  pending from is equal to double inverted comma 0   double inverted comma close comma double inverted  comma done double inverted comma close comma if   cracked open time taken in completion is equal to  double inverted comma zero double inverted comma   close comma double inverted comma pending double  inverted comma clothes bracket flows and we will   close the bracket till it doesn't get black enter  now we will drag this till end we will be going to   conditional formatting so that we can highlight  it highlight cell rule text that contains done   we will highlight done as green okay conditional  formatting once again highlight cell rule text   that contains and we will put pending we will  leave it as red so it's done now we will be   putting the formula for the comments and the  formula will be plus or equal to if bracket open   information date is equal to 0 comma  double inverted comma 2 times comma if   bracket open completion date is equal to 0  comma double inverted comma take follow-up   double inverted comma close comma if bracket  open time taken incompletion is smaller than or   equal to 10 comma double inverted comma good job  double inverted from a close comma if bracket open   time taken in completion once again is bigger  than or greater than 10 comma double inverted   comma needs more Focus needs more Focus heavily  noted comma flows and we will close the bracket   till it doesn't get black enter we will drag  this till end now we will highlight it we will   be going to conditional formatting highlight  cell rule text that contains needs more Focus we will leave it as red again we will be going  to conditional formatting highlight cell rule   text that contains and we will put good job  over here we will do it green okay again we   will be going to conditional formatting highlight  cell rule text that contains and take follow-up   we will do it here now you will do okay one  thing more we will have to insert drop down   over here for the department so we will be  going to data data validation over here we   will select list and we will type the source so  our department where operations training it HR   and we will do okay and over here drop down is  created. I'm sure you must have loved the video.   Please don't forget to like share and subscribe  see you soon with a new topic till then Bye Bye