Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Row sum based on column value?

Andrew Buck
edited 12/09/19 in Archived 2016 Posts

 

Here is a bit of an odd ball.  This is a budget sheet that has been simplified for this question.  At the end of each quarter the planed amount is replaced with the actual value for the quarter.  I need to sum up the total actual and the total planned across all quarters for use in other calculations.

 

Is there as way to sum across all columns but only include a quarter based on the value of the row that says actual or planned?  The goals would be for the user to come in at the end of the quarter and change the header for a quarter from planned to actual and enter the actual amount spent.  As it is now, the user has to edit each formula (shown) to add another actual and remove another planned.  It seems to me that there should be a smart(sheet)er way to do this, but I'm too much of a newbie to figure out how.  Thanks!

 

Screen Shot 2016-02-12 at 2.47.45 PM.png

Tags:

Comments

This discussion has been closed.