Forum Discussion

bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
2 years ago

Create ID for each weekday time1 and time2 based on the sample data

Hi ,   I need some help as the ID is working for all weekdays but not for friday.     Sample data google drive link https://docs.google.com/spreadsheets/d/1kMgzehh1inILMJ7VA-EuHR36vsv53Jc...
Need Help
bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
2 years ago

Hi Dufo,

Current source data has 3 columns Index, Date, time like below

 

 

Expected output is 4th custom column ID need to created and time1 and time 2 values needed for each weekday.

 

 

Attaching source sample data with below link and sorry for the trouble caused by me.

 

Sample Data 

 

 

 

 

 

  • dufoq3's avatar
    dufoq3
    Icon for Community Champion rankCommunity Champion
    2 years ago

    You're still repeating the same and not reading. In previous post you have a link with solution.

    • bhaskarpbi999's avatar
      bhaskarpbi999
      Icon for Helper V rankHelper V
      2 years ago

      Hi Dufo,

      I have link and the solution is working for All days except friday where it is displaying time1 and time1 instead of Time2 that is the only issue.

       

      Thanks for your whole hearted support.Kudos any tricks please help me.

       

      Regards,

      Bhaskar