-
Delete task dependency
I'm trying to delete one task dependency on a Gantt chart. I found this quick YouTube video, which says to click the dependency line, but I'm unable to click on it. My dependency lines are not green like in the YouTube video. Thoughts?
-
Feature request - dynamic lists
Dynamic lists would be a very valuable feature in smartsheet. When we add a new employee to our system, we need to add them into about 10 different sheets, so that they can select their name from the relevant lists and fill out a timesheet, project reporting etc. If the new employee could be just added to a dynamic…
-
Linking
I was wondering if smartsheet linking has the capability to perform this following type of function: If I create a Request Log spreadsheet, and one of those columns has a drop down with options, approved, hold, pending, is it possible to create a function wherein once that approved selections has been made then that row of…
-
Webhooks API
Hello, Does anyone have any good examples of using the webhooks feature of the API to send notifications to Slack? I'm not sure if I have everything structured correctly in Smartsheet but, essentially whenever a certain cell in a sheet (that could live in a specific set of Workspaces), I would like to have a slack…
-
Horizontal Reporting (Transpose)
Hi! I'm currently having some issues generating a report from smartsheets that enables be to do some additional reporting away from the product to enable external sharing (due to data, and legal reasons). I'm looking at building a milestone report however the current report that is being generated in smartsheets is more of…
-
If/Or Statement
Hello all, I am relatively new to Smartsheet and have hit a wall in trying to automate a RYG. I am looking to change the color by listing multiple possibilities from a range of cells. My idea was to create a separate column for the formula, hoping to return a "1" or a "0". Then I could add a simple formula in the RYG…
-
Chart Columns
Notice in the attached picture that I have a chart that shows how much reimbursement a specific client received last year and as of the current date the client has received almost half of that. The issue is that the FY1718 (Red) column appears too small for the actual result. Visually, shouldn't it be about half the height…
-
Adding rows and data types with C#
Hi Everyone, I am currently trying to integrated SharePoint data into smartsheet. However, I am struggling with data types and most of the cells do not take my values. I think I have no issue with certain type like TEXT_NUMBER or DURATION but for the other types I am stuck. Can someone show me an example of how to insert…
-
Smartsheet collaboration with Microsoft Teams
Hi, I want to know the accessibility rights of the different types of users (licensed, non-licensed, collaborator...) Example: I want 2 users to be admins so they can add users and create sheets. And I need 20 users to be able to access the sheets, input, and edit information. Also, I need 100 users to be able to view the…
-
Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test") I'm not working in excel - I just wrote up the…
