Hi guys,
I am just starting with the scripting and I am really trying my best. I have learned a lot just by trying out different submissions from the community and by doing that I understand how a script is structured etc.
I am currently focused on 3...
Hi guys,
I would like to create a formula to display the following status for our CYCLE spreadsheet.
Cycle is ongoingCycle has not begun.Cycle has ended.
So there will be only 2 date fields ( Date: Start and Date: End) to indicate when the cycle is s...
Hi guys,
First, credits to @Jeremy_Oglesby for this awesome workaround. Since I cannot message him directly here, I am hoping that he catches this! Thank you so much for this!!! My coding skills are not good and I have been trying to figure this on m...
Hi @kuovonne
Thank you for still replying and trying to help me out. I have taken your response and I have been studying it. So what I did was to try to combine the 2nd script and 3rd script. I have tried to adjust it as well.
What I want to happen i...
Hi @kuovonne
Thank you for your detailed response. I appreciate the effort into explaining the theory as well. I understand it more now that the design is different and yes it is run through automation not like compared to the other 2 which is run th...
Hi Andre,
Thank you so much for replying to my post!
Uhmm based on how I understood your code. It assumes that the Start date is blank. But usually we already place a date on the Start and End date in advance since we plan the cycle/sprint in advance...
