-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
How do I create a pie chart from the data on my sheet? Assuming I need a formula?
I have a column with rows of dollar amounts called Grant Amount and a column with a drop down menu of three options called Scope of Work. My goal is to create a pie chart on my dashboard showing what percentage of the total amount of dollars from the Grant Amount column is going toward the options chosen in the Scope of…
-
Formula & Placement for Automating Status based on End Date
Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it! Goal: Automate Status column updating When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.'…
-
Formula & Placement for Automating Status based on End Date
Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it! Goal: Automate Status column updating When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.'…
-
Can someone please help with this formula?
I keep getting an "invalid operation" error message with this formula. Can someone spot where I went wrong? I am not great at formulas. The goal is for multiple criteria (IF statements) to match before entering "Inactive" in the cell. =IF({Master Cadre Roster Range 1} = [First Name]@row, IF({Master Cadre Roster Range 3} =…
-
Calculating a total for remainder of month based on a monthly savings
When the date is mid-month, I am missing $ amount for the partial month. Example below - the annual savings = EOY 2025. Formula used in Annual Savings is: =IF(OR(ISBLANK([Savings Start Date]@row), ISBLANK([Monthly Savings]@row)), 0, (12 - MONTH([Savings Start Date]@row)) * VALUE([Monthly Savings]@row)) I have tried several…
-
Formula not working
I would like my cell to look at a cell@row to see if it = 1, or if another cell = minus 150. If either one of those is true, "1", if not " " =IF([Minus 180]@row = "1", OR([Incremental Start]@row = "Minus 150", "1", " "))
-
Overall Health Symbols at Parent Level
Good Morning, I am trying to add health symbols that will tell me the overall health of my project as well as the individual phases withing said project. Below is currently what I have at my children level for health symbol formula. Children Formula for Health Symbol: =IF(COUNT(CHILDREN(Tasks@row)) = 0,…
-
Best Practices for Copying Multiple Sheets
I have about 10 source sheets that I need to copy to a new sheet. They have most of the same columns, and they are tracking the same type of information for different projects. I've attempted to merge them onto one report, but there are duplicate columns (and nearly 1,700 rows), and I don't know how to unify things so the…