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.
Year to Date calculation, This Year vs. Last Year
I am trying to do a year to date calculation on some sales data but would like to bais it on this years sales vs last years sales to keep track of how we are doing month by month. Do I need to do a horizonal lookup? A sumif? Is there a way to add a current date to the sheet, then simply do if sum if >= to this date? Please let me know if you have any ideas.