My company is moving to Smartsheet to consolidate what we normally keep in multiple locations. One of these locations is Excel, where we track project spending and budgets.
I've figured out how to use cross sheet referencing to calculate costs and credits and have them show on the master budget tracker. It was a bit of a chore (compared to just clicking a cell/range/etc on another tab/sheet within the same spreadsheet), but I worked it out.
For the formula we use to cross sheet reference, we us IF & SUMIF to designate construction codes and apply debits and credits to each code in a master budget tracking sheet. In excel, we created a custom cell formula (#,##0.00) that automatically displays a negative number for the credits column.
The rest of the formula follows basic IF/SUMIF logic and returns the desired results every time. Sweet.
I do not see that there is a function to have values in a column automatically display as negative when a value is input as shown below in Excel. Here, 200 or 360 is typed and automatically displays as a deduction.
I reformatted my normal Excel formula to compensate for the change to SS syntax and have made everything else work exactly as it does in Excel, the only exception being that the credits instead show a positive number that is then deducted through the formula. Sweet enough. However, the higher ups want to be able to look at a value in the credits column and see that it's reflected by either ( ) or a negative. I'll change the formula accordingly if I can get these values to display as described.
I would LOVE for this to be something super simple that I've just overlooked. I was asked to take over SS integration within our company, but not before all of the training time was used by the people who passed this off to me. Still, the community has been most helpful and I'm hoping this is a "DUH" moment for me.
Thanks in advance for any help!
