Daily manpower
I am having trouble creating a consistent formula to track how many workers will be on site for a given day. Based on the start, end time, and count of manpower for each task, I have used that as a reference for a SUMIFS() formula in a separate column. I have also added a date column that shows a list in ascending order of dates until reaching the finish date. The formula created works for the first date which is the start date. For any other day a result of zero will appear. Here is the formula that I have so far.
SUMIFS(Manpower3:Manpower38, Start3:Start38, @cell >= [Work Day]@row, Finish3:Finish38, @cell <= [Work Day]@row)
I have even tried to lock in the range for manpower, start, and finish and still result in zero. If anyone has a solution it will be very helpful.
Best Answer
-
Why exactly are you specifying rows 3 - 38?
How exactly is each data point being entered?
Have you double checked that the date columns are in fact date type columns?
Answers
-
Are you able to provide some screenshots for reference?
-
Why exactly are you specifying rows 3 - 38?
How exactly is each data point being entered?
Have you double checked that the date columns are in fact date type columns?
-
There are not any formulas for Start ,End, or Workday because I removed the formulas. Man power is calculating a sum of the columns to the right for the worker type for each Task. Yes I have checked that the columns are in the correct format.
Man Power = SUM(LABORER@row:WELDER@row)
-
I just realized that the formula you posted and the formula in your screenshot do not match. The formula in your screenshot has the operators reversed for the dates. The formula you posted should work.
-
The formula works as long as the finish date is equal to the start date. Is there another operation to get the formula to calculate the days in between two dates?
-
Thank you Paul for responding to the discussion post I have figured it out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!