How to Complete the Daily Power Drops Report in Smartsheet

Learn how to use Smartsheet WorkApps to track daily project completion percentages, batch update task statuses, and submit your end-of-shift Man Hour Form.

May 21, 2026 By Drew Stewart

This guide outlines the daily procedure for updating the power drops tracker in Smartsheet, from logging individual task progress to submitting your end-of-shift hours.

This workflow applies to Electrical Supervisors and project leads responsible for daily site tracking and ensuring labor hours correspond correctly to project progress.

Accessing the Project Tracker

To begin your daily report, you need to open your specific project workspace within Smartsheet WorkApps.

Step #1: Click the More (...) icon at the bottom of the left-hand taskbar and select WorkApps. — Click the **More** (...) icon at the bottom of the left-hand taskbar and select **WorkApps**.

Depending on your account permissions, your WorkApps dashboard will only display the specific project applications you are assigned to manage.

Step #2: Select your assigned application card, such as Electrical Super for Grove City 3.0. — Select your assigned application card, such as **Electrical Super for Grove City 3.0**.

Step #3: Click the relevant PDF or sheet name to open the project's tracking table. — Click the relevant PDF or sheet name to open the project's tracking table.

Updating Daily Task Progress

Once inside the data grid, you must record the completion status and percentage for the day's tasks. You can edit individual tasks or use keyboard shortcuts to batch-update consecutive rows.

Step #4: Click into the Daily Percent cell for a completed task and enter 100. — Click into the **Daily Percent** cell for a completed task and enter `100`.

Step #5: Click the corresponding Daily Status dropdown and select the appropriate status, such as Complete - missing material or Complete. — Click the corresponding **Daily Status** dropdown and select the appropriate status, such as **Complete - missing material** or **Complete**.

Step #6: To batch update multiple adjacent tasks, highlight the updated cells, copy them, and press Ctrl + V to paste the values down the grid. — To batch update multiple adjacent tasks, highlight the updated cells, copy them, and press **Ctrl + V** to paste the values down the grid.

7

For partially completed tasks, enter the current completion metric (e.g., 80) in the Daily Percent column.

Step #8: Update the corresponding Daily Status to In Progress. — Update the corresponding **Daily Status** to **In Progress**.

Step #9: Click the Save icon at the top of the workspace to apply all of your pending grid updates. — Click the **Save** icon at the top of the workspace to apply all of your pending grid updates.

Make sure you save your grid changes before navigating away to the submission form, or your daily progress updates will be lost.

Submitting the Man Hour Form

After ensuring the project grid correctly reflects the day's labor, you need to file the overarching man hours for the shift.

Step #10: Select Man Hour Form from the left-hand navigation sidebar. — Select **Man Hour Form** from the left-hand navigation sidebar.

11

Enter the supervisor's name into the top text field.

Step #12: Click the Cell name dropdown and select or type your specific work location. — Click the **Cell name** dropdown and select or type your specific work location.

13

Enter the total number of workers on your crew in the Power drop team size field.

14

Input the total duration worked into the Daily hours field.

Step #15: Click Submit at the bottom of the form to finalize your daily report. — Click **Submit** at the bottom of the form to finalize your daily report.

Your report is successfully filed once the green confirmation banner appears at the top of the form view.