-
Web form entry ID based on URL click-through
Hi Guys, This might be a long shot. My team needs a way for our sheet to automatically assign an ID to a web form entry based on some pre-existing set of meaningful ID numbers. e.g. a handyman was called out to the customer's house to do maintenance work. we have a reference number for that particular job callout (say,…
-
Allowing users to only add a row to a sheet and view only those rows
New to Smartsheet and hoping this may be a simple question.... I want to be able to create a sheet that anyone in my company can access, but with the following permission groups: 1. Admin (full access) 2.Edit rights (limited to specific users, columns and rows) 3. View rights (limited to specific users, columns and rows)…
-
how to connect smarsheet with Oracle Database
Need some ideas around connecting the Smartsheet to import data from a database based on a parameter.
-
Here is a Time Keeping Smartsheet
I have seen a few questions about time keeping in Smartsheets. I created a smartsheet for this exact purpose. We have been using this for almost a year now and it is working great. This sheet makes it easier for everyone in the office. The employees get a much faster response to their request, it has cut down on our paper…
-
Insert Row: Automatically Links Cells
I am trying to figure out a way to best organize my project tracking... For example, my company has four big projects coming up, let's call them projects A-D. We have organized our sheets by project, and then created various sections within the sheet for each team working on the project, with sub-sections for task…
-
Project light status, Entire Row format & due date
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/2015 overdue/ At risk in both cases, Start date is pedecessaor to Proposed finish date and Finish date. So when we have a…
-
Adding system columns in the confirmation email?
Hi, I have two system columns: an auto generated number to represent order number and a created on timestamp. When I create the web form, I want these two fields to be added into the confirmation email so that when a user submits the form, they can see their order number as well as the timestamp. Is that at all possible?…
-
Publish a Sheet with Cell Linking
Hi I am in the trial phase with this software and am hpoing you can help me understand publising a sheet with cell linking. I have published a sheet that has cell linking to stakeholders who do not have login credientials for SmartSheets. When they review the sheet, they cannot click on the cells that would link them to…
-
Removing Resources
Novice question, I'm sure. Building a project plan, i had added "placeholder" users until the roles were filled by actual people. Now that I no longer need the placeholders, how do I go about removing resources from the list to eliminate clutter? Thanks in advance for any help with this.
-
Start No Earlier Than
Looking for a way to add a "Start No Earlier Than" clause into a sheet? We want to link Task B to its predecessor, Task A, but also indicate that Task B must start no earlier than a certain date. This way if we modify dates/durations for Task A, it modifies Task B while still noting the earliest start date. Any help?