This is an elegant solution for auto status calculation. I attempted something similar in the past; however, the problem I ran into, which made me abandon the effort, was handling non-work days like holidays and weekends in Excel. Does your template handle non-workdays? Very nice delivery of the concept.
@@ld3607 The only way to do this is with Google Apps Script. Unfortunately this is one of the limitations of Gsheets. I usually just turn each option into a column with a checkbox. But this only works if you don't have too many options
King of google sheets 🙌🏻
Super helpful thank you!
Very helpful and informative! Thanks Michael!
Hustle sheets number 1!
Very nice!
Amazing!
This is an elegant solution for auto status calculation. I attempted something similar in the past; however, the problem I ran into, which made me abandon the effort, was handling non-work days like holidays and weekends in Excel. Does your template handle non-workdays? Very nice delivery of the concept.
Learned a lot from you man. Where is the array video? 38:31
Hi! Do you have a video explaining how to add multiple options in a dropdown menu?
Hi, do you mean that you want to select more than one option in a dropdown?
@@hustlesheets correct
@@ld3607 The only way to do this is with Google Apps Script.
Unfortunately this is one of the limitations of Gsheets. I usually just turn each option into a column with a checkbox. But this only works if you don't have too many options
@@hustlesheets that sucks 😕
@@hustlesheets the truth is that I need it to work with a dashboard/graph that I want to make eventually
perm papi project manager
Hello sir I need this free template urgently please to show in my portfolio sir
Lol
🎊 𝓅𝓇o𝓂o𝓈𝓂