-
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…
-
I'd like to have a permalink to Comments
I'd like to have a permalink to Comments in certain rows so I can send people a link to a specific comment if need be. For instance, I have a comment on a row that is important for people to see. I'd like to be able to (like we have now "Email Comment") copy a link to that comment and send people via Slack or some other…
-
Filter "is one of" drop down lists
Is there a way to clean up the drop down list on "is one of" filters? They still contain items that have been totally deleted from the column being filtered. This is very confusing to users. Thanks
