-
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
-
Best time tracking software for Smartsheet?
Does anybody know of a good time tracking software that I can integrate with Smartsheet? Specifically, I am invisioning using a third-party time tracking software and be able to link the information (i.e. billing to date, hours, etc.) to my Smartsheet spreadsheet or Smartsheet Sight as a one stop shop with various other…
-
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…
