-
Need formula help
I'm trying to match info in another sheet and return a date column to the first sheet. I've tried a few things but keep getting errors. In Sheet A each row is a job number. I want to fill in the job completion date from Sheet B. It has many job number rows with different job types. The Job type column is Parent/Child. I'm…
-
Lookup Value and Count based on the input criteria
Hello Team, I am trying to bring a formula to look up a value and bring the corresponding counts. The input sheet will look for the "Date of" column and dynamically generate the Yesterday or Today value based on the formual i have written for "Yesterday/Today" column. There is a person going to enter #New Hires, #Leavers,…
-
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…
-
COLLECT function and validate ISDATE
Hi, I am new to Smartsheet. I am trying ISDATE(COLLECT( function to pull an array and validate whether the values are dates. Is there a workaround? Similarly COLLECT(REPLACE( is there a workaround to modify the array?
-
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,…
-
Anyone resolved 'automatically adding rows to a sheet based on a trigger value' ?
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…
-
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!
-
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)…