-
Cell Linking for Updates?
I'm trying to find a solution to reduce the number of updates my team and I have to do. We currently use Smartsheet to create and manage project plans but also have a master "Status Sheet" that lists all projects, their current task, and the deadline of this task. Whenever we update the project plan, we also have to update…
-
Notifications
Within Alerts & Actions, I know how to send a notification to an Email Address within a specific column of a sheet via the "Contact in column" and selecting the column. That is working great. My question is whether I can send this notification, with a CC to me. I know I can clone the original notification and send it to…
-
Anyway to disable keyboard shortcut ctrl+1?
I use chrome and I use the keyboard shortcuts for switching between tabs. The first tab from the left is accessed with ctrl+1, but in smartsheets this hides and unhides the toolbar. Is there anyway to disable this functionality so I can switch to the first tab quickly? I use pinned tabs so I can't make shartsheets the 1st…
-
Automatic letter send when drop down field is changed
I would like to set up an automatic "customized" email (letter) to the person who filled out the form (they submit their email into form). I would like this to occur when I change a drop down field in the spreadsheet.
-
Is anyone using an Air Pen or scanner to add data to a sheet?
We'd like to enter data from hard copy files into a sheet. We've found air pens or scanners, but we're not sure if we can use them with Smartsheet.
-
auto populate start date based on sprint number OR vice versa
Smartsheeters, I am looking to auto-populate start date based on entering a sprint number. OR to auto populate sprint number based on start date- I assume that finish date will be auto populated based on duration entered (10d). I am fairly new to smartsheet so keep that in mind Any ideas? or Articles to share? Thanks,…
-
Is there a formula for averaging the remaining?
Hello again! I have been trying to figure out a formula for averaging the remaining. This sheet has all business days through Dec 8 and a certain number of tasks to complete each day to be finished on time (Dec. 8). There are two columns. One has the number of tasks due to be completed each day (labeled Average) and the…
-
Prevent column name from showing up in Sight
This topic has been discussed before, but, for whatever reason, that discussion is frozen. When using the metric widget in a sight every selected cell will get the name of the column it's in as a passenger. While I can't find any reasons for this approach, it would be nice to have an on/off switch. I know one can remove…
-
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
-
Sharing With Non-Licensed Users
I have shared many sheets with non-licensed users. They do not have a problem accessing them with the initial email but do not know how to find them later. Are they able to access them if they type the Smartsheet URL into their web search?