[Solved] Using C#, how do I get all rows from smartsheet where “x” is in column 2?
Below is the code I managed to find after a little more searching: public void GetJobNoOfAllProjects(SmartsheetClient smartsheet, long sheetId, out List<string> matches) { jobNoMatches = new List<string>(); Sheet sheet = smartsheet.SheetResources.GetSheet(sheetId, null, null, null, null, null, null, null); foreach (Row tmpRow in sheet.Rows) { if (tmpRow.Cells[2].Value.ToString() == “PROJECT”) { //Do what is required to the … Read more