Hello all,
I am building a Google Sheets hourly work count that would show total hours/pay. I need to display the calculation based on the response to other cell.
For example:
If user inputs rota for the whole month, excel would count all the hours. However, I want it to show that calculation only if "Shift Complete?" cell says "Yes" ("Shift Complete?" cell will have a drop down that show "Yes" and "No").
Any ideas as to the best way to execute this?
Bookmarks