HSabin
HSabin
Reactions
Discussions
- I currently have a ledger report (Report A) that pulls in budget data from two sheets. In Report A, the report groups the line items by brand and provides a SUM of budget per brand. I'm needing to cre…
- Hi! I'm stumped on this one. I am using a column formula to apply a date 21 days prior to the date in another column. Everything (formatting, etc) is the same on all the rows, but I keep getting "Inva…
- I'm trying to sum up two budget columns, based on the budget type in another column. For some reason I keep getting errors and can not figure this out. =SUMIF(Program:Program, "BDM", [PO Raised]:[Plan…
- I have a "ledger" sheet that I use to calculate real-time budgets based on any changes and shifts that come through a request system. Currently, it's built for F24, however as we move towards F25, I w…
- I have been working on testing out some reporting and dashboards. In a proof of concept report I built, I was able to add 2 summaries for Count and SUM. This report included the "$" in the summary (se…
- I am pulling in data from another sheet based on conditions in the sheet. I can't figure out how to hide the formula error if the value from the other sheet is blank. There will be many cells with bla…
- I'm building an approval process/workflow for a finance team and I'm curious if there is a way to restrict number inputs to positive numbers only?
- Is there a formula that will mark a flag red based on conditional formatting of other columns in a row? For example, I've set up multiple conditional formatting rules within a tracker sheet. I'd like …
