-
Past Due Reports
GOAL - Tasks Past Due Report for Multi Sheets I have several sheets with the columns set up as seen below: (Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and % Complete is not required so it's left Blank. (Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column…
-
Advanced Notifications: Stay on Top of Important Changes
I have been waiting for these more advanced notifications for a while now. Thanks for getting this to a much happier place. I tried creating a generalized "team" notification when any given shared user is assigned a task, I would like them to receive the notificaiton. From what it looks like currently, this is possible,…
-
Formula to add or subtract value based on item selected in drop down list
Hi folks, I would like to create a formula that can identify the item selceted in a drop down column and then automatically add a value based on the item selected in the drop down to the next cell. Example if the item i selected from the dropdown list in column a was "deduct 10 points" I would like the formula to…
-
Conditional Notification / Alerts
Hi Smartsheet Community, I recently posted a reply on the smartsheet blog (https://www.smartsheet.com/comment/46032#comment-46032) and Diana Ramos kindly replied letting me know that Conditional Notification might soon be available. Diana asked me to add a thread here to capture and direct the programmers to ensure our…
-
Sights
I am using smartsheet to collect problems and ideas coming from various areas of our company. As a result I have a large sheet in smartsheet where all the data is being collected and then I am using sights to display an overview of problems and ideas. My query is where is the best place or method to gather all the…
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
CARDS - Add parent title to the card
Is it possible to add the parent title to the card as well? It would make it a lot clearer which item you are working on when the parent is different but the child is the same. For example we have a lot of tasks such as: Design Part 1 Develop Schematics Create BOM Create Layout Drawing Design Part 2 Develop Schematics…
-
Transferring my personal account to a business account
Hello, We are considering a business account at my company, and until now I have had a personal account (that I use for work). With this transfer, we will buy additional licenses for other people in my office. A couple of questions regarding this: - can I transfer my existing account to the new licenses? I don't want to…
-
Starting time with predecessors
Is there a way instead of using a starting date, I can use a starting time? I have tasks to plan during the day for maintenance, this usually doesn't take more than a day. I want to use gantt view as well. I know the hour function has been added recently as I understand, so why can't I add up the hours starting from a…
-
Sheet Sharing
I have a sheet that I "save as new" weekly in one workspace. The workspace has 7 people but the sheet I share weekly has 5 additional people who do not need to be shared to the entire workspace but do need to see that sheet weekly. Any advice on how I can keep these people saved to the sheet without having to add them each…
