-
Helper Sheet Help
@Andrée Starå has mentioned on multiple posts about creating Helper Sheets when trying to manipulte data to have certain rows copied to other sheets. I'm completely stumped where to start with the cross-reference formulas to make that happen. I have a master sheet with a lot of columns, some of the data in the master needs…
-
Index Match
I am trying to use and Index/Match equation to pull data from one SmartSheet to another. My Course Dev Dashboard SmartSheet contains basic information for all projects that we currently have in development. Each of those projects has its own SmartSheet with details from the contract to track progress. I'm trying to use the…
-
Weighted AVG.
looking for some help. the formula I'm using =SUM(IF([INSPECTIONS %]@row, 0.1, "100%") + (IF([ROUGH IN %]@row, 0.4, "100%") + (IF([CABLE/WIRE %]@row, 0.5, "100%")))) * 100 + "%" I can't seem to think of a way to make this work with any % that isn't 100% Also if I use =AVG(CHILDREN()), on the Parent row it just says #Divide…
-
How to convert to a date
HI all, I'm trying to get a text string from one column (lot code) converted into a date in another column. The first column contains numbers such as: 202405 Ideally the date column would read the first four digits as a year, and the last two as the month (all of the days can be the first). So far I have: =DATE(LEFT([LOT…
-
Using OR with JOIN COLLECT
I'm struggling with the syntax on this one. I have this formula that in its current state Joins and Collects if both Sales Lead and Sales Lead 2 match [Metric Grouping]. =JOIN(COLLECT({Master_Event and Year}, {Sales Lead}, [Metric Grouping]@row, {Master Event Info Sales Lead 2}, [Metric Grouping]@row), " | ") However, I…
-
How to Use SUMIF Function for Sheet Summary
Hello! I am trying to use smartsheet to support budget tracking. I'd like to summarize the amount spent and section by our spend category. So if my Cost Center Category is equal to "Paid Media" I would like a sum of all rows meeting this criteria. So my range headings are Cost Center Category and Amount, my Criterion is…
-
COUNTIF showing "0" when referencing a column where cells have formula
Hello! Please help! First I have one sheet (Pre-Service) with several columns, three of them used here, the first two are dates, and the third is a calculation to determine the number of weeks between the two dates. I used (=(([Anticipated Graduation date]@row) - ([Pre-Service Class Start Date]@row)) / 7). So far so good.…
-
Finding the date that a cell changed value.
I wish to look at a status cell and work out whether it has changed in the last 7 days or not. I want to use this as part of a formula so I could say has status changed in the last 7 days yes or no and then be able to use that information with other info to generate reports so we can see where action is required.
-
Combining formulas - not working
Good morning! I have each of the following formulas in a separate cell and works just fine. However, I need it all in one cell but cannot seem to figure it out without getting error messages. Hoping someone can help me. I must use the contain function bc its pulling data from a text column. Also I want to add that if the…
-
Can I get help with this formula?
=(IF(OR(MBE@row <> " ", WBE@row <> " ", MWBE@row <> " ", DBE@row <> " ", ACDBE@row <> " ", "Done")))