-
VLOOKUP to Gather Monthly Adoption Number based on Country
I am trying to find a way to create a metrics based on our monthly adoption numbers, this is the sheet that im trying to take the data from and then enter into the applicable fields in my metrics I want to take if its Global, and if the month is ex: January, take the Online Adoption Rate total and copy it into my metrics…
-
Pulling Values from referenced sheet cell, where mutliple values exist in the cell.
Using the following formula to pull values from a source sheet, when it matches a cell in my current sheet. =IFERROR(INDEX(COLLECT({eITCR # (Open)}, {eITCR - Open AI}, HAS([InfoCard Number]@row, @cell )), 1), INDEX(COLLECT({eITCR # (Closed)}, {eITCR - Closed AI}, HAS([InfoCard Number]@row, @cell )), 1)) The issue I have is…
-
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,…
-
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,…
-
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…
-
Formula history is now viewable in Cell History in table view
February 09, 2026 Users can now view the history of any formulas entered into a cell using the Cell History feature in table view (an improvement over the current grid view experience). Learn More Environments availability: Commercial US, Commercial EU, Commercial AU Plan availability: Pro, Business, Enterprise, Advanced…