forecast formula for projection

Options

Simon Martinez

Simon Martinez ✭✭

11/17/21 in Formulas and Functions

I'm trying to have a cell provide me with a projected fee spent in $ in the forecasted $ column based on the remaining % of completion

Any help or guidance would be much appreciated!!!

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

11/17/21
Options
Couldn't you subtract the Fee Spent from the Project Fee?

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

MAX children date if another children column is not blank
I am having an issue with a formula. I need to capture the children's max date for Closed Date only if all children's Location cells that are not blank have a Close date. With the sample below Currently, the Parent Close date would be blank as not all of the Locations 1-4 have a Close Date. If all four locations had dates,…
Identify MAX Date for each employee
I have created a list that tracks the number of days an employee is out. I need to identify the most recent absence. An employee can be on the list more than once. I would like to use the MAX function to identify the most recent absence for each employee by checking the box in Max Date. Is there a way to do that? The…
Multiple IF ERROR in a single formula
Hello, I am trying to get a status to pull from 3 different worksheets depending on the Row ID (We have current items, past items, and future items to keep our sheets from being too full. I get an #UNPARSEABLE error. Please let me know what I'm doing wrong. =IFERROR(VLOOKUP([Row ID]@row, {RANGE1}, 22, false),IFERROR…