-
Smartsheet Calendar Populates on Outlook Calendar
Hi, If we use the Outlook Smartsheet app, will calendar items on Smartsheet be pushed to the users Outlook? Thank you, Jared
-
Custom Report Format Possible?
I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way. For instance if I have the columns and 3 rows. * Publish Date * Category * Title * Body Text…
-
Mail Merge with Google Docs: combine into one file
I'm doing a mail merge using Google Docs, which works fine except when I try using 'combine into one file'. I've seen a previous discussion where the pagination was an issue but mine is fine except it changes the font! Can anyone tell me where I'm going wrong? Thanks!
-
Will locking a parent row lock the children?
Hello, I am looking at creating a way to track monthly time sheets. Ideally, I would like to have parent rows for each month with numbered days beneath. In theory, I would like to have an option where the supervisor approves that month, and then it automatically locks the entire month. This would mean that it would need to…
-
Legal projects/task management sheet
Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all main "legal work" categories and then broken down to sub categories, tasks and then sub…
-
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…