-
Detecting Cell Changes, Modifying other cells on update.
Hey guys. So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur. The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: =IF([% Complete]2024 = 1,…
-
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…