I'm trying to pull a specific number out of another SmartSheet based on it matching information in one specific cell. I don't know if Index/Collect is the best way to do that but that's what I've been trying. The criteria is Description 2 being somewhere in the cell of Budget Range 1, Description 4 being somewhere in…
I've attached a screenshot of my report of our budget. The column called Budgeted I originally had named Budgeted 2024. When I renamed it to just Budgeted, I deleted off the Budgeted 2024 column, refreshed, and added the new Budgeted column. I now can't get it to sum.
I'm trying to only add up budget line items from specific months and that do not contain the value "Total" in their account code. Here's the formula I have and just can't get right. After breaking it apart, I'm finding the CONTAINS part of the formula is what's incorrect. =SUMIFS({Budget Detail $}, {Budget Detail Acct…
I need a report that shows all projects each employee is associated with under the Team Member column from a multi-select list. Because of the multi-select, I can't run a report and group by Team Member. My work-around was to create a separate sheet that would just pull every project name associated with the employee on a…
