-
Submitting a row to two sheets broken by SDK updates
We have a form on our site that adds a row to two sheets in Smartsheet. This broke in June at which time the form added a row to the first sheet, but failed in the API call to Smartsheet in adding a row to the second sheet. Example Code that submitted to the first sheet (this was not affected): protected void…
-
Update VIA API not showing updates
Hello There Super Noob to Smartsheet APIs. I am updating smartsheet, with Powershell, a Test Sheet sending simple sample data. It shows that I have added multiple row, in the test sheet, but it isn't showing the data even if I refresh the sheet. I have no Idea whats going on.
-
Countifs with OR across multiple columns
Hello all, I'm a fairly new (2 weeks) smartsheet user and I'm trying to write a formula that will count several columns based on specfic criteria. I want to count the number of Open projects (status) that are associated with engineering by either person/dept assigned column 1 or 2, and are of a safety concern (category)…
-
Auto Link Active Directory Emails in SmartSheet
Looking for process or procedure to add when customizing a field to add a user from Outlook and have it pull from AD or Exchange
-
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…
-
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…
-
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…
-
Smartsheet to SharePoint
Can Smartsheet integrate with Microsoft Flow and be triggered by a Smartsheet row update vs a sheet update. I want to flow updates from my Smartsheet by row/item to a SharePoint list by item.