-
Multiple Entries of The Same Name Into A Single Row
Good morning, I am newer to Smartsheet so forgive my lack of knowlede. I have created an attendance tracker form to track employee call offs from for our supervisors. Is there a way for example if John Doe calls off 3 days but each day is a separate submission due to different supervisor working, if each of John Doe's call…
-
Why is report showing Target Date as a Formula and not allowing adjustments?
Good Morning! My master sheet has a Target End Date column that is formatted as a date column. For some reason, on my reports, it is now showing this field as a formula value and not allowing updates directly from the reports. Does anyone know how I can correct this? Thank you! Julie
-
Adding Calculated 'Report' Column into a Report
we need to make some calculations on summarized data in reports. such as summing up two or more column values or dividing two column's values in each other to get a percentage value from them. Calculation have to be functional not only in data rows but also in summary rows in a report. My suggestion is to make a calculated…
-
Dashboarding Annual Calendar: Best Practice
Trying to develop a calendar/dashboard to reflect the major milestones of all projects happening in the PMO and having a difficult time! I haven't been able to find a dashboard visualization that easily displays all projects at a high level with callouts for project milestones.. I tried a timeline widget (see image below)…
-
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 multiple selection
-
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 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…