-
Counting number of items from a specific month with multiple criteria
I'm trying to count the number of items that were published for each LOB in our operation during each month. I've tried a dozen different formulas, but I can't seem to get any to work. I currently have a sheet summary with the following: =COUNTIFS([Received Month]:[Received Month], IFERROR(MONTH(@cell ), 0) = 1, (LOB,…
-
Need some formula assistance
Hello! I am usually pretty savvy at figuring out formulas, but I am truly stuck on solving this one. Does anyone know a way to solve for the below situation? I feel like it's doable and likely easier than the way I'm trying to approach it, but cannot get the right combination. Background: Our project plans/schedules have…
-
How do I get a parent row to change based off a child row value?
I am creating an action item report. I am wanting the parent row to show when the child's row column "Action Item Completed" in NOT checked mark. In the below example the report would show the Notes column of: Action Items… Olsson to send… Olsson to schedule… City of Lincoln…. I created the helper columns Ancestor and…
-
Cross-sheet formulas not returning all results
Hi- I am trying to link data between 2 different sheets. I created an INDEX/MATCH formula to pull in information related to "Phase" from a Master sheet into another sheet. I am using a unique code to link the information. The formula is only returning 8 results, and returning no values in places where I have verified there…
-
How to restore conditional formatting, parent child relationships, and formulas?
Hello, I am trying to restore sheets to exactly what they were, with conditional formatting, formulas, and parent child relationships intact. Is there any way to do this? I am not a software developer, but I would very much appreciate any help the community can give! Thank you!
-
Urgent help please! How to restore a sheet exactly as it was?
Hello! I need urgent help please! Is it possible, either locally on Smartsheet or with a third party platform, to restore a past version of a sheet to an identical format? I have tried the local Smartsheet backup, ProBackup, and am troubleshooting Fluentpro Backup. All have trouble with parent child cell relationships,…
-
How Can I Combine Multiple Percentages Into One Cumulative Percentage?
I'm working on a project that has multiple components connected to the overall goal. To better know where we're at, I've created a done category to track progress in a percentage based on when a new box is checked. To accomplish this, I used the following formula: =ROUND(COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0)…
-
Auto-populate parent/child rows in a separate sheet?
Hello! I was wondering if there was a way to have certain column data automatically transferred to another sheet. Once that data is transferred, I would like for that transferred data to automatically populate into an existing parent row (if the account name matches). Example: Sheet 1 is a request sheet that is auto filled…
-
How do I run this report?
I have a sheet where there are several different "Assigned To" columns and then a "Project Status" column. I need to create an employee workload report. Each report should only show that employee's assigned to tasks that are in their current status. For example: Deron's report should show the row Project Name and Project…
-
Date minus # of days to get new date
I am trying to have the Drop Dead column subtract 42 days from the Final Confirmation Date. I have the Drop Dead column setup as a Date Column and have tried doing this formula, but am getting an "Invalid Operation" error. Can anyone tell me what I am doing wrong? And thanks in advance.