-
Create an Entry on a worksheet based on the value of another worksheet
Problem Statement: We have one sheet (we will call it, Sheet A) which records the joiners/leavers for our company. In order to track whether the leaver employee returns his/her equipment, I wanted to create an entry with data from Sheet A on another sheet (Sheet B) based on two sets of criteria from Sheet A, Type (leaver)…
-
When will the API get some attention?
I'm using the smartsheet library, and it works pretty well, except that checkboxes always return None, no matter the value. I submitted a bug to the repo on github, and linked it to some other folks that noted the same problem on StackOverflow. For the tool I'm trying to build, I really need that feature to work, or at…
-
Formulas to calculate data received from web form
This is a screenshot of my page that I want to try and get the formulars for. The cells that are in yellow, the data in those cells will come from my staff that I have complete the web form that i have attached to this sheet. The red cells are the ones that I require the formulas for to calculate the different times that I…
-
Notifications - Changes to cell also notifies when cell is created
Currently I have a sheet that set set to receive data from a smartsheet form. That form puts the data at the top of my sheet. I have a checkbox that is checked by default in the form [column name: New Employee]. I also have an alert that says if column "New Employee" changes notify me right away. Now at this point I have…
-
Cell linking
Hi, I was wondering if it is possible to link my sheet to another sheet that will automatically generate new entries. I have a master log in Smartsheet that i use for all the background check information that only an internal team has access too. When i filter though for a certain company in that sheet I would like to be…
-
Cell linking - finding the next empty row on another sheet
Hi, Looking for a way to link a cell in each new sheet to the 1st column of the next open row in a summary sheet. I have a template sheet and summary sheet. I would like to create a number of sheets from the template and then display some info from the sheet in one row on the summary sheet. It looks like this is commonly…
-
Hours tracking conundrum
Hello, I'm a new user who has completed my 1 month trial and had a 30 min session with a SS expert. However, I still haven't figured out how to make SS do what I want it to do. Specifically- I work for an 8 person consulting firm with an average of 70 clients at any given time. Sometimes one consultant works with one…
-
Recurring KPI Reports
Hello, I'm looking to utalize SmartSheet to document querterly KPI (performace reviews) I'm looking on a way to setup the indicaters on a report and have our team leaders fill out reviews for all team members, what is the best way of using this via SmartSheet. Your helo is greatly appricated. MH
-
Problems writing zip codes starting with Zero "0"
Hello there, I'm unable to put in zipcodes starting with "0" in the Text/Number Column, it autmatically removes the zero's leaving only the whole numbers behind. Is there a way to disable this feature? Regards, Paul
-
How to set up a departmental time off request sheet?
I was wondering how I could set up a document that is one sheet for time off. The main things we need are a form or something to fill out that will go to the employees specific manager to approve or deny, and will then notify the employee if it has been denied or approved, and if approved, will then populate in the sheet…
