-
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.
-
How to Format Salesforce Date in Smartsheet for 30-Day Archiving Automation
Hi there, I have a sheet that pulls in Department Events via Data Shuttle from Salesforce. The issue is that I want events to archive off the sheet after 30 days. However, the date format coming in looks like this: 2026-03-16T00:00:00. Smartsheet automation doesn’t recognize this format. I tried creating a helper column to…
-
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…
-
MIN(COLLECT( function issues
I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E). [A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a…
-
Show Duplicates Based on Multiple Columns
Hi, I was looking for a solution to showing "Duplicate" if the combination of ColumnA @row and ColumnB@row of the same row appeared more than once. After taking bits of advice to similar problems in the community forum and reviewing the Smartsheet functions list, this formula solved my problem. I thought it would be worth…