-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
Using cross sheet reference to pull data from one column in Sheet 1 into multiple rows in Sheet 2
I have two sheets. Sheet 1 is essentially a directory. It lists all of the individual contacts that are involved in a project. Some columns in the sheet are are "Name" (Contact List), "Title" (Text), "Department" (Text), and "Completed Assignments" (Text). Sheet 2 is where monthly assignments are recorded. The columns are…
-
How can I return a value in one column from another sheet based on two inconsistent string criteria?
Hi, any help with this will be hugely appreciated. On my master sheet I have a "Task Name" column, an "Audience" column and a "Description" column I want to populate with this formula. On the source sheet I have a "Task Name" column, an "Audience" column and the "Description" column I want the data from. Unfortunately, the…
-
Data Shuttle - Excel File Not Connection/Mapping Not Working
Hi all, I have an Excel file in a shared folder on SharePoint that I want to upload to Data Shuttle. For some reason, the table does not want to map. I know I have the correct tab and row numbers selected, but I'm still not seeing a Unique Identifier dropdown, just "Please select a Source in order to see dropdown options."…
-
One of the Sheets in my workspace keeps losing all of its data
Hello, I have 2 sheets currently in one workspace. The first sheet works as expected, it saves my changes when I save. The second sheet, I imported an Excel file to it. I made a couple of changes and saved. When I returned to the sheet it was blank. I did this three times with the same result. If I click into the other…
-
Referencing the Row Above in a Formula
Hi all! I am trying to create a formula that compares 2 values in the same column. One on the current row, to one on the row right above it. Every row represents a separate week, and I want to compare metrics from the current week, to last week, and based on the result (>,<,=) a symbol will appear. I found a post where…
-
Copy Certain Row Cells to New Sheets
Good morning! I came across this thread (https://community.smartsheet.com/discussion/92237/copy-specific-columns-from-one-sheet-to-another-linked) but it doesn't look like it's had any traction since early 2023. I'm hoping this is still something that is in the works and figured I'd see if anyone has come up with any work…
-
Deleting Cross Sheet References // Reference Manager
Anyone else not able to delete Cross Sheet References? I have a total of 8 CSR's that I have Deleted multiple times...but they keep showing up again in the Reference Manager. I even deleted the column in the source sheet that the reference was pointing to and they still won't completely delete... I submitted a support case…
-
How to give access to specific people ONLY to specific columns of a master sheet?
Dear Smartsheet team, I would like your input on the following topic: We have created a Workspace for one of our customers, that contains a master sheet that stores Tactics, with various different columns. We have a request from our customer, to add 4 more columns to this master sheet, related to the Tactics, and give…