Welcome!

IFNUMBER formula, help!

Good morning all,

I am trying to create a formula that essentially does a planned budget value - actual budget value to get the "budget variance" but only if there is a number in the actual budget field. Any suggestions? Right now it is only:

=[Budget Planned]26 - [Budget Actual]26

But when we have no actual numbers in there, it is making our budget variance quite large.

Find more posts tagged with

Comments

Mike Wilday

Try surrounding your formula with an IF statement.

=IF(Isblank([Budget Actual]26), "", [Budget Planned]26 - [Budget Actual]26)

That should give you a blank cell if there is no data in Budget Actual, but give you your formula if there is actual amounts listed.

You would paste that formula into row 26 and use the bottom-right corner to drag it up and down throughout your sheet.

Hope that helps!

Sign in to join the conversation!

Quick Links

Trending discussions

Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?