Formula Help!

I'm creating a dashboard that contains some metrics. I have my metric worksheet already setup and have pulled over info. I'm needing a particular formula and cannot seem to figure it out. Here is what I'm working with:

I need to search one column of information for any input values for only the past two weeks IF a different column contains a certain name.

Column A: Company Names

Column B: Dates

Column C: # values from 1-10

To visualize I need to pull the # values from column C for the last two week (column B) only if column A contains a particular company name.

Is this possible? I've been searching and searching for over a week now and have tried so many different formulas. Thanks for any and all help here!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!