# Forumla help: pull over number based on date

edited 06/11/20

@Paul Newcome Hey Paul, reaching out for your help again. I've got a field log sheet that I'm hoping to automate. I've figured out how to count the number of panels erected automatically, but now I can't figure out the number of men column. The number of men/day stays here's a published sheet.

The challenge is it's not really doing any counting or math, just pulling over a number from the #men column, here's a filtered view of 4/16. I only want 8 to automatically be pulled into the number of men/day column for the day the work was done, its not adding or counting.

• ✭✭✭✭✭✭

Hi Sean,

I’ve added the formula to your sheet and also updated the formula for the ”Number of Panels erected by day”.

I've simplified the formula with @row, and also I removed the @cell because it's not needed.

For the Number of men/day I used:

```=SUMIF(Erect:Erect, [Erection date]@row, [# Men]:[# Men])
```

For the Number of Panels erected by day I used:

```=COUNTIFS(Erect:Erect, [Erection date]@row)
```

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• @Andrée Starå Thank you. The simplification helps, but the sumifs is not what i'm looking to accomplish. The way the same number of men erected the panels on the day so the number should only be 8 on 4/17

• That's perfect. Thank you

• ✭✭✭✭✭✭

Excellent!

I'm always happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• @Andrée Starå one last question, how can I make the number of panels cell be blank instead of zero if none?

• I unlocked the column

• Thanks!

• ✭✭✭✭✭✭

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!