-
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)…
-
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…
-
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…