Linked Cells with Numeric Value not working in Chart Widget

Hi, I have a roll up of numbers for the total of checkboxes checked off in our main data sheet. I've linked that totaled value into a separate sheet via the link cell capability.

That is somehow not getting charted, and is showing up as "Invalid data"?

What am I doing wrong?

Find more posts tagged with

Forms

Sheets

Formulas

Reports

Integrations

Project Management

Cell linking

Comments

Alejandra

Hello,

I'd recommend checking the column properties for the column containing your formula and for the column containing the cell link to ensure they're set to one of the available column types listed here: https://help.smartsheet.com/learning-track/smartsheet-advanced/charts-dashboards

If needed, more information on column types can be found here: https://help.smartsheet.com/articles/504619-column-types

Sign in to join the conversation!

Quick Links

Trending discussions

Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
Retrieving Cell info if another column falls between specific dates
Here is the formula I am trying and it's brining back #CIRCULAR REFERENCE =IF(AND([FPI Date]@row >= DATE({StartYr}, {StartMth}, {StartDy}), [Jan FPI]@row <= DATE({EndYr}, {EndMth}, {EndDay})), [eCOA_ID]@row , "")
Index/Match
I have two sheets that are capturing two different sets of data. Sheet 1 (Billable Mileage Log) is capturing projects that have been marked as needing mileage to be entered in a different platform. Sheet 2 is capturing mileage that's being entered via a Smartsheet form. On this sheet, I have two columns that have formulas.…