-
Moving reports, sheets, and dashboards
Can you move sheets, reports and dashboards into different folders within the same workspace without damaging the cell linking and references? All of the items to be moved are already in the same Workspace.
-
Unique cells referenced in cross-sheet formulas Limit - How is this calculated?
I received an error today that stated "Some cross-sheet formulas can't be updated, because this sheet has more cells referenced from other sheets than the maximum allowed (100000)." Its a pretty generic message that doesnt tell me which formula is not being updated nor which cross reference formula is causing me to hit…
-
Carry over proofs to a linked sheet?
Is there a way to automatically carry over proofs to a linked sheet?
-
Merging Data
Combining Rows and merging their content would be very useful.
-
Adding Condition to IF Statement
Hello! I have a smartsheet setup that is collecting data for an asset library. Part of the data is to assign ID numbers when specific values are met. I have 3 columns, I have a stock ID column that is populated manually with tock IDs. Then I have an internal ID column that is auto-populated via smartsheet when the stock ID…
-
Use countifs to count all projects with a quarter date and year from a date column
my current formula is =countifs({sheet reference}, ROUNDUP(MONTH(@cell)/3) = "4", {sheet reference}, Year(@cell) = "2022" I have ensured the column from the reference is a date column, however I am given invalid data type as an error
-
Error 5262: "Unable to create the requested cell link(s). The source data is no longer accessible."
Hi, I'm getting this error message when attempting to create a link from a cell in another sheet (through creating a cell, a row, and then update_rows method). Has anyone seen this error? I'm reading a discussion on another thread that this error is related to some issue with profile data (?), but I can create this link…
-
How to link specific fields from one sheet to another sheet?
Sheet #1 has two Columns, let's say they are titled "Name" and "Fruit". Under "Name", is a list of names i.e. Mitch, Sarah, Elizabeth, Pete etc. Under "Fruit" says apple, orange, kiwi, etc. I want to create a new sheet (Sheet #2) that could reference Sheet #1. For instance, if column "Fruit" in the first sheet says…
-
Create a Drop-Down List from Another Smartsheet
Greetings! Does Smartsheet include a feature that allows for the creation of a drop-down in which the selection choices are pulled from a column in another Smartsheet? Thank you, John
-
One Data Set, Multiple Calendars
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
