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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!