-
Formula to auto calculate time difference in hours between two 24hr format times?
I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format. Once picking their starting time and end time, I would like the third column, "Total Hours", to…
-
Indent from a form
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come in indented so I have to manually indent each row as it hits the sheet.
-
Summary
I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. Does anyone know what would be the best way to complete this? Thanks!
-
Row edit feature and sheets
Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by different areas. One of the areas prefers to work in the edit form to see the information vertically…
-
Deleted user still able to access Smartsheet
Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been deleted are still able to access into Smartsheet when they log on with a password but not single sign on. Once logged on they…
-
NEW TO SMARTSHEET...QUESTION
Good Afternoon, I am very new to smartsheet and still trying to find my way around. I am wondering if it is possible with smartsheet that if you have a drop down menu if 1 particular option is chosen could you have other drop downs pop up?
-
Product Development Testing Template Set
I've reached out to our account manager and also sent a request via the web form, but have not heard back from anyone. What I've been looking for is the "Template Set" for the Product Testing solution (Test Plan, Test Log, Bug Tracking & Submission and Bug Report). I've reviewed it "Create New -> Browse Templates" but…
-
Limitations free trial users?
Dears, Our customer has a number of unlicensed users which work on Smartsheet. A new employee joined and created a new free trial user account. This user is not able to email comments out of a sheet: "You've exceeded the maximum of 5 recipients at a time for free trial users. Please reduce your list and try again." Any…
-
Urgently in need of an response from Smartsheet
I understand this is not a place to deal with indivisual cases, but as I cannot reach anyone in Smartsheet, I've decided to write here. Thought I've been trying to contact Smartsheet since mid-November either through "Contuct us" on the website or directly with a sales representative, I haven't received any response yet.…
-
Ranking Tasks
I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks that they want us to complete - with numbers - 1 through 25, for example. If they create a new task for our team and assign…
