-
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…
-
Data Mesh scheduling - new row in the target sheet
I have a configuration with Execution Frequency = Immediate and Data Mapping Format = Create Cell Links. When I add a new row to the target sheet, mapped cells do not get their link in the new row. If I change the schedule to 1 Hour, links are added. Q: If all my mapping is Create Cell Links, then I don't need a frequency…