-
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…
-
Time based totals
We use Smartsheets for project management. We have about 100 projects of short duration that span over several months. We would like to assign staff to each project then be able to see how many staff members are needed during a given week. I picture a number on the Gantt chart bars that show staff on the bar. Somehow a…
-
Reports - Hide Data from Master Sheet
Hello, It is my understanding, that in order to share a report and allow for users to also make edits within the report, that they also have to have visibility of the master sheet that the report is pulling data from. Is it possible to share a report with users, while still allowing them to make edits, without allowing…
-
Does anyone have a grant/program management template to share?
I need a template that will help my team track relatiosnhip management, and grantee relatiosnips- especiallly regarding grant milestone progress.
-
Copying Links of a single cell to multiples on another sheet
Has anyone else had a problem copying a link to one reference cell to multiples on another sheet? We have the problem of trying to link a single reference number on a master sheet to a group of candidates on a second sheet. Functionality-wise I want a change in the master board to immediately update on the secondary list…
