-
Planned vs Actual Charts
Hi everyone! Looking for suggestions on how to show planned vs actual in chart format. In Excel, we can have a line that shows numbers or percentages for planned and another for actual and then put it into a chart which shows the planned line and then actuals in a bar graph. I've provided an example below. Looking to do…
-
Language Translation Process
Hi Smartsheet Community, We are trying to develop a process within Smartsheet, that essentially allows us to create a repository of processes in English, and once english is entered, it then translates into French, German, Spanish but all on separate sheets. I was thinking about reports, but it doesn't really give us the…
-
👋 Hi everyone, I’m happy to be here!
🏥 Where I work & role I’m a Grant & Development Coordinator at a community-based organization that is also a certified culturally specific behavioral health provider. Our work blends behavioral health, community health services, public health programming, and a cancer support center. 📊 Background & Smartsheet experience I…
-
Add new rows/line items in reports
Bi-directional information is what makes reports awesome. Being able to add new rows directly within a report would be helpful if I only want some people working in a certain report so that they only see certain information. They could then work directly within that report and not have to bother with other reports/sheets.
-
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
-
Track changes in a data element over time
A customer of mine would like to be able to see what rows in a project plan have changed their task status over a given period - probably a week. A scenario would be in preparation for a weekly team update meeting, the customer would like to be able to see a summary of what has changed from 'Red' to 'Yellow' or 'Green' and…
-
Tracking changes
Hi, I'm wondering how to track changes that other team members have made in our shared sheets, if someone could let me know how to do this or if there's a report I can pull down, that'd be great.
-
Some clarification to clarify
I have a few questions that I need clarification on: This is a question about multiple selection able to run report and auto counted and group in report I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in…
-
Changes over Time - COUNTIFS?
I have a project where a group of users can submit a smartsheet form at any time to request a new enhancement to one or more of 3 tools. One of these tools is managed by an outside vendor and therefore management wants to be able to track number of enhancements submitted to them as well as how they progress through status…
-
Does anyone have a project plan used to bring Smartsheet into your company?
Looking for a project plan that I could use to bring Smartsheet into my company. We are going to be needing SSO Control Center Building Templates for Control Center Building out connectors (mainly for Azure DevOps) Creating Reports (for projects but also for users to see open tasks by project assigned to them) anything…