-
Grading multiple deals with multiple people
We want to use smartsheets to rank 35 companies 1-5 on five different fields. To further complicate this it will be done by 7 different people. We will then sum the information together on a separate shet. Any idea how to accomplish this?
-
critical path
Hello! The critical path is not showing on the Gantt chart I created. Do all of the activities need to have a predecessor? There are some activities that are not linked and I wonder if that is the issue. Please help! Thanks!
-
I am sure I am missing something simple
New user here, just made my first form to be filled out and submitted by multiple users. I have one submission now, but I want to view it in more of a "pretty" Q&A style, almost as if I could pull up my text form and see his responses on there. Is this possible? Thank you!
-
Rows doubled in target sheet when using Copy Automation
I have a "Control" sheet where I run an automation to send update requests to users monthly. When the update has been has been applied and reviewed/completed, a checkbox is checked which triggers an automation to Copy the row/responses to a history sheet. The first issue I'm facing is that the history sheet receives 2 rows…
-
Conditional formatting in alerts
How can I get conditional formatting to display consistently in messages sent through alerts? I have one sheet where this works well, and colour-coded rows appear as just as they do in the sheet itself. However, I have another sheet where only some of the formatting is shown, and none of the colour coding (which is based…
-
Card View - View by Status dropdown
How can I add or change the options in the dropdown feature of "View by Status"? It automatically select some columns from the grid view but not all. I need to add a specific column to the dropdown.
-
Summary data populated from column entries
Is there a way to automatically populate summary data fields based on the entries in a particular column, rather than having to identify all of the unique values and add summary fields one by one? For example, column 1 contains multiple instances of person 1, person 2, person 3, etc, and column 2 contains numeric values…
-
Resource View
Is there a way that I can have the resource view displayed as a bargraph or gnatt view. Ideally I would like to group my resources by project with a 3 week outlook graph. Thanks Cindy Bowker Glastech Glazing Contractors
-
Looking to create a data reference across tabs to determine row value
We have many columns that need to be reviewed by this formula - within these columns, multiple answers will return the same value. For example: Column A could show Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep. All those are considered Cleanup. However, if we change that drop column to Oct or Nov, that column is now…
-
filtering on primary column
I am trying to apply a filter using the primary column but when i look for any of the values nothing is returned. the column is locked but I have tried it both locked and unlocked. any ideas?
