-
SharePoint Deployment Plan Template
Does anyone have a Template plan to build and deploy Sharepoint?
-
Storing a SmartSheet form in a Sharepoint document library
I have a SmartSheet form I want people to complete, but want to use a SharePoint document library for all the submitted forms. What's the best approach to getting this done?
-
A formula for totaling question
I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of each category option. It appears I can't do it directly so I thought of building a…
-
Drop Down Menus
Hello, I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done? So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection. Thank you!
-
Establishing connection between Informatica Power Center and Smartsheet
Establishing connection between Informatica Power Center and Smartsheet
-
Using "@row" reference with ";" as the separator
Hi the community! I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";" When I use the "@row" reference in a formula, then extend this formula and come back to it, the formula separator becomes ",". So if I modify the formula without…
-
Sharing a report but not the source spreadsheet
I want to share part of a spreadsheet with a subcontractor. However, I do not want them to have access to the full sheet. For instance, source data: A B C D E F G H Data to share with subcontractor. They also need to be able to edit/update columns A, B, C. A B C According to the help page, this is not possible, but maybe…
-
Help Desk Ticketing templates
I am working on leveraging the Help Desk template to manage our customers' IT tickets. Requirements: 1. I need for the submitters to receive an auto acknowledgement of their service requests. 2. I need for the technician to be able to communicate back and forth with the submitter via the ticket. This will allow the…
-
Auto-assign sequenced number to new project(s) sheet
Is there a way to automatically assign a uniquely sequenced ID# to each newly created project sheet? We'd like to do this for/across a group of users that collaborates on short-termed projects (3-6 mos). Basically have the application assign a unique and automatically sequenced ID# for each new project. Thanks in advance.
-
Alerts and Notifications not working
I am running an evaluation of Smartsheet. I have turned on Alerts (right away) so that Supt. can get notification whenever there is a change on a sheet. Those alert notifications are not be being sent out. I have tested it several times by updating the % Complete (yes I have that one as part of the alert). But the changes…