Forumla help: pull over number based on date

@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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!