-
Contact List Clean-up
Hi, I'm new to a company, and new to their sheets as well and in trying to clean up an older sheet of existing consultants, it has former consultants listed and they get populated in the weekly schedule occasionally. I can't seem to delete them because they're not in my personal contact list (screenshot of contacts I can't…
-
Workflow Manager not opening on a specific sheet.
Hello, I am on day 3 of not being able to access the Workflow Manager on our most used sheet. This specific sheet is the only one that is giving me this issue when trying to open the Workflow Manager and we need to make some changes as soon as possible. Does anyone know what may be causing this? I have contacted Smartsheet…
-
Will moving sheets to a new workspace risk breaking connections, cross sheet formulas, reports, etc?
Just a quick check before I potentially ruin months of work: I built a robust tool, complete with dozens of cross-sheet formulas, Data Shuttle workflows, reports, metrics sheets, dashboards, you name it. If I move them all together to a new workspace, will I break anything? I understand the permissions will change. Just…
-
Searching for the nearest date in another sheet
Hi everyone, I would need a formula where it picks the nearest date in the past related to today's date in another sheet. To give more context, the other sheet always shows Mondays as dates. I tried Index and array but it seems not to work. Would appreciate a template. "Today's Date" cell is based on a formula, I inserted…
-
Weekly Reporting of Symbol Column
Hi, I'm struggling with how to implement a change in how we report project status (red, yellow, green). For each project we have a sheet that holds the reporting data (I've hidden most columns to keep it simple - just project name and health). Health is manually set by the project manager. This Overall Health field is used…
-
Formula to count days a row stays in a certain status?
For a contract management sheet, we are using a drop down single-select to choose the contracts status, ie. new request, attorney review, awaiting signature... I want to measure the average time any row stays in a certain status. The idea is that we can track how many days on average attorney review takes, or how many days…
-
CARD VIEW: Filtering Subtasks within the Parent Card
Scenario: Within Card View, I have a Parent Card titled "Water Account Plots" which has 5 x subtasks (seen in red below) These correspond with the subtasks seen within Grid View Within Card View, if I FILTER by Person 1... Result: The result unfortunately still shows all 5 x subtasks within the parent card? (and I was…
-
Create Report source sheets? - Merge with same primary?
Update: It works correctly but when I filter it shows the filter on two rows. Can I make it merge all rows with the same primary? Hi, I created a report and pick both source sheets. The source sheets have the same primary ID however not in the same order. After picking the sources sheets, I pick the columns I want, those…
-
Summarise Blank Columns
Hi, I have a sheet that tracks onboarding actions for new employees with a new row for each employee and the actions required as columns. It's getting a bit wide and messy though and isn't easy to tell what actions are outstanding for each employee. Can anyone think of a clever way summarising outstanding actions -…
-
How to align column in when grouping reports
I am grouping a report on a given column (e.g. column A) and showing all rows under that group. However column for grouping is still shoing a width which i wish to get rid of. as shown in below or in attched document. Equipment xxxxxxxxxxxxxxx Part 1 xxxxxxxxxxxxxxx Part 2 I have used xxxxxxxxxxx to show spacing only here…
