extract the SUM of projects from a certain date range on differnt sheet

Options

Connected Sensors

Connected Sensors ✭✭

01/09/23 in Formulas and Functions

Hello All, Im trying to figure out how to extract the SUM of projects from a certain date range.

Essentially I have a Sales funnel and want to find the the revenue forecasted within a certain date range.

IM also new to the this so and completely lost

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

01/10/23
Options
You would use a SUMIFS formula with cross sheet references.

https://help.smartsheet.com/function/sumifs

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

I am trying to get the percentile of responses that return "1-2" if the responded "4 Months" in
I am trying to get the percentile of responses that return "1-2" in a column if the response is "4 Months" in another column. =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, "4 Months", 0.5)) or =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, {Survey Time}, "4 Months", 0.5))…
COUNTIF where counting if cell contains "Super" but "Superstar"
I have a formula where I'm counting how many products are at a certain status and where they have a title of Super, Super & more or Super & Design (B&W) - but want to make it scalable. Is there a way to create a formula where I can tell it to count any cell where "Super" is the prefix? And secondarily, not count anything…
COUNTIFS with multiple OR dates
Im trying to use a formula that counts the number of projects where it fulfills certain criteria that then checks whether the startdate was after a beginning date range or the end date was before the end date range. (basically that work was performed within the date range). This is what I have: =COUNTIFS({Marcom Portfolio…