-
Create a resource view
I have a number of sheets with a large number of people on a team all doing part of the work. The Report feature is good at showing the tasks on a gant chart across the business but it presents it as one line per task which means that there are possibly 15 lines for one person. Thats a bit difficult to manage. The calendar…
-
Replicating multiple worksheets in Excel
We use an xls file to manage our monthly staff rota. I want to transfer this to SS but we use multiple worksheets, one for each month, ie one for Jan, one for Feb etc. What is the best practice for replicating this functionality on SS please? Thanks. Michael
-
Web form question
Does anyone know if the web form functionality will incorporate a slide bar rating scale? This exists in Surveymonkey and my Marketing team still uses Surveymonkey regularly because of this feature vs SmartSheet web forms. thanks!
-
Formula referencing cell in newly submitted row
Hi all, I fear this may be impossible, but it's always worth asking. I have a simple time logging sheet with a web form that just asks what project a user is working on. I have system columns use the time stamp from the web form to log the time. I am trying to use the difference between the submitted time and the last…
-
Resource Planner with Location & Dates
Dear All, has anyone created a resource planner that shows day by day location such as onsite, offsite, vacation, public holiday etc.? I would like for two columns with the resource name and the resource role and then the rest of the columns should be the calendar with the column showing the day and date for the month. An…
-
Viewing PDF's on Android app?!
Hi, I am starting to use the Android app a lot more for viewing my sheet but when I go to open a PDF it just shows a black screen in the PDF viewer. Does anyone know what is going on? Thanks.
-
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…
