-
wrong order of the assignments
Hello, During the last week i noticed that the order of the assignments in the sheet got wrong. Assignment number 1 became 10 (for examle). I have about 1000 assignments in this sheet it's really a big problem for me. In the beginning i tried to organize it again in the way i want to see it (and according to the row id),…
-
interaction on dasboard metric widget
Hello community, here is my problem: I have a planning on a sheet with a lot of differents actions. Some of them are complete, some others are not started or late or on hold, etc. I have also a dashboard where appears the numbers of my actions by categories with metric widgets. And now i would like to create an interaction…
-
How to manage Order with multiple items
I'm creating a form to collect Order information from users and facing a difficulty with an order having multiple items. I want to create a form which allows users to input multiple items in one order request. Each item will have each price and quantity. How can I do that in smartsheet? Thanks.
-
Formula Help to Add Symbols
Hey guys - I have a unique request. We use sheets to create project plans for Clients and set up a Column called 'Stoplight Status' using red, yellow, green, etc. colored circle symbols in the cell. Anyone know how to create a formula to sum each category of color? Client is requesting this snapshot. Thanks for any help…
-
Holidays not showing
Hi. I have loaded holidays under account settings and they are recorded on that admin screen, but they are not being reflected under new projects (in Gantt view). Any ideas?
-
Any column below the stock Level, status become to red.
Hi, As per the attached and formula, How can i add the formula if Week 15,16,17~52 any column below the stock Level, status become to red. I'm only know the formula for single column. =IF(ISBLANK([Stock Level]2), "Yellow", IF([Stock Level]2 <= [Week 14]2, "Green", IF([Stock Level]2 > [Week 14]2, "Red", ""))) Thanks in…
-
Risk Management Plan
I am creating a RM plan using the SmartSheet template. What goes into the Sections Impacted & Distribution area of the document?
-
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…
-
Feature request: copy share link to clipboard
I would love to save myself a few clicks by having the "Secure sheet link (accessible by shared users only)" link available in the main UI. My mock-up of this would be something like the attached. A user could just click that small hyperlink icon and the share link would be copied to their clipboard for pasting. I do a lot…
-
Linking to a published report from a word document.
I publish a report in calendar view for our staff to view upcoming programs, see their status, notes etc, and one member of our staff uses this for a staff newsletter each week. This link is saved in a word document. Just this week, after the recent roll-out of the UI upgrade, when following the link from the word…
