Calculating formula for total pay for hours worked?
Hi, I'm wanting to create a timesheet where 1hr = (ex.) £10, and hours can be input by an individual and the smartsheet will work out how much they are owed. First calculation to be row, 5hrs = £50, second calculation to be the total of the column 5x £50 = £250.
Is there a way to assign a value to a number e.g. 1 = 10, so .5 - 5 and 2 = 20?
Answers
-
Hi @nicole.turner,
How about a sheet for e.g. a month with one column "date" (type: date), one column "hours" (type: text and numbers) and one column "total" (formatted as currency) and one column "rate/h" (formatted as currency).
Either have a top row to roll it all up (use indentation), or a bottom row where you sum up.
A formula sitting in the column "total" will SUM all hours in the column "hours" and multiply it with the value in the column "rate/h".
Example: =SUM(hours:hours) * [rate/h]1 (1 = the cell where the rate can be found)
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Hi @Stefan - I don't know if I'm doing something wrong, but each new row that is added via the form all adds up to the amount of the first row - I'm unsure what I'm doing wrong. Each new row generated, the Rate/h changed on the rows below to reflect the row they're sat on.
I have created on the form a hidden box with the Rate/h set at 25 so it auto populates every new row added. How do I get the formula to reflect the differing hours on each new row, rather than just using the newest/original?
-
Hi @nicole.turner ,
maybe my misunderstanding.
The formula I sent was meant to count all hours, because I thought you or others enter date into that sheet and you wanted to sum it all up. hours:hours takes all entries from the column "hours".
Ok, you enter data via a form and you want the column only to show the cost of each row, right?
Then: =Hours@row * [Rate/h]@row
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives