-
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…
-
Changing date from Outlook
Hi- I'm trying to set up Smartsheet to track follow up on a large number of small projects. Using the smartsheet for outlook app with the web-based version of outlook (my desktop is 2010), I am not able to update a column with a date from outlook. I am trying to set up a system to alert me if I haven't received an update…
-
Need for darker lines and dates on printed calendars
I export my shipping dates to a sheet that presents the data as a calendar that is printed and posted for our shipping packers and loaders. This is a great tool for allowing those on the team who are not on the computer to plan their workflow. The default color for the calendar grid as well as month and date labels is…