Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Create SUMIFS formula

I need help creating a formula that will show the sum of the Forecast Amount for any Opportunity that has one of these Sales Stages:

1 - Prospect

2 - Assessment

3 - Proposal

4 - Contracts

If it's easier to write one that includes "everything except", these would be the ones to exclude:

Closed Won

Closed Lost

All I come up with is UNPARSEABLE.

Thanks in advance for your help!

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions