-
Returning A Symbol Value From Another Sheet
Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to reference) "Trends", and the second sheet "This Week". In "Trends", every row represents a week, and ta the end of every row…
-
Is there a way to ONLY have one cell unlocked?
Hi all, I have created a sheet full of formulas that ALL reference one cell. I would like to lock down everything BUT that one cell, so functionally anyone with access could change the reference cell and see the consequence of that change. I realize that I COULD move this one reference cell into its own column, but before…
-
Intake form/Sheets to Document Builder - Font issues
Hello! I created an intake form that captures data onto a sheet. One of the automations I built out is to create a PDF. However, upon creating - I am having issues with the font size that is being populated. The fillable pdf itself has conditional formatting on font size. The smartsheets sheet itself has a formatted font…
-
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…