-
API not returning conditionalFormat info
I have a smartsheet that uses conditional formatting. I want to be able to make a call to the API requesting information about the row's conditional formatting. My api call, C# - Row row = smartsheet.SheetResources.RowResources.GetRow(sheetID, rowID, new RowInclusion[] { RowInclusion.COLUMNS, RowInclusion.COLUMN_TYPE,…
-
Cell Linking Max Count
So when I try linking a cell I got the following error "Your sheet has 5000 inbound links" I understand that this is the maximum number of links but, what is considered an inbound link? For instance, I know that the linkInFromCell Objects can have a status like "OK", "BROKEN", "NOT_SHARED", "INACCESSIBLE", and some other…
-
Undo question
Hello, I was editing a formula and somehow the whole sheet appeared with the error #INVALID OPERATION. I was trying to undo the last change to reverse it, but the button wouldn't appear enable and the sheet was saved! I invested a lot of time ==(. Is there anyway to recover the previous version of my sheet? Thank you.
-
Very annoying jira sync problem
Hi There, UPDATE: i tryed a other project and that did seem to work, so stories remained in the same position, disconnected from parent story or epic as intended. I think, my updates just never got synced. Am i correct when i say that when a story is allready present on the sheet, the position is not being updated, what i…
-
Smartsheet jira connector row issue
Hi all, I have a project sheet which is connected to jira. Everytime the connector gets updated some of the rows that i have arranged/sorted get moved in smarsheet. Is there a way where i can fix the rows in one place and only the fields can get updated when the connector is updated. The locking row option doesnt help…
-
API Bug: GetSheets returns rows with null SheetId
I'm running into an issue where SheetResources.GetSheet and SheetResources.UpdateRows are returning rows with a null value for their SheetId. Has anyone else run into this issue? I'm not passing in any parameters other than the target SheetId. I'd like to determine if I have a configuration issue or if this is a bug in the…
-
Sight Template
Hey, do you guys have a template for Sight? I see that there are many for sheets but none for Sight, and the bank Sight listed as a template only redirects to an empty Sight. Would really appreciate a templace as I don't see how to modifty the width and height of the objects I'm trying to import onto Sight. Best.
-
Populate a Sheet from SQL server query (C#)
Hi Everyone, I need some help with a fairly simple task we are trying to accomplish -but i am having some hard time getting it to work - We are reading from a SQL server and some of the result needs to be populated into Smartsheet. As i am using Dataset - and trying to update each value on the variable "ProjectName" into a…
-
Smartsheet to Outlook Tasks
In my Smartsheet projects, in addition to the usual statuses of "complete", "in progress", etc. I have a status called "Action Item" where I designate items that I personally need to take care of. Is there a way to make these items appear as "tasks" in my Outlook? (reason: I prefer to block off times for my tasks in my…
-
Power Bi dashboards?
Hi Community i'd be interested to know how useful members are finding the Smartsheet linkage with Power BI to create some excellent Graphical dashbards possibly as a supplement to the more Numerical View achieved in Sights? Could any of you describe your Use case? Could you describe how easy or Difficult it was to set up?…
