-
Web Forms - Set Schedule/Reminder
We recently decided to utilize Smartsheet for creating regular meeting agendas and created a web form that could be sent out internally to give employees the opportunity to submit their input/items for the agenda. I wonder if there's a setting or plan for the future to have web forms be automatically sent out to users on a…
-
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