-
Trying to build a good, dynamic task list
I'm working on getting a good personal task list system going within Smartsheet. I've gone through a small number of efforts to get what I need, but I still have a problem around getting something dynamic and quick functioning. 1. Built a task list based on the task list template. With no automatic sorting, I have to sort…
-
If N/A checkbox is marked note % complete as 100%?
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Thank you!
-
Week Numbers
How do I display a week number in a field, that references of a date field.
-
Automatically add tasks to a web form populated row
Hi, I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form? I review sets of data that are submitted by multiple business unit and partner companies. The form this takes in always the same, and we have a set…
-
Cell Deletes When Highlighted
If a cell is selected, it automatically clears itself if nothing is typed or clicked within 5 seconds. Can be infuriating when trying to modify a smartsheet.] Happens in Windows Chrome and Internet Explorer.
-
Cell Restrictions
Hi there Does anyone know whether you can add restrictions to cells (or columns/rows) to specify the number of characters/words used? For example, i'd like to restrict some cells to a maximum of 30 words, to ensure people don't input excessive descriptions. thank you!
-
Using or not using hierarchies
For sales I have been advised not to use heirarchies to group things by areas like likelihood, potential size, stage of progress, etc, because once they're a few pages long it's a bit unweildy. I was advised to use no hierarchies for a sales pipeline and instead rely on Reports for all of that. But I see that with the…
-
Gantt Chart layout - weeks
I am aware that you can create a Gantt chart view by showing the week of the year. Is there a way to configure the layout to show the project week? Thanks for any assistance. Mike
-
Allowing users to only add a row to a sheet and view only those rows
New to Smartsheet and hoping this may be a simple question.... I want to be able to create a sheet that anyone in my company can access, but with the following permission groups: 1. Admin (full access) 2.Edit rights (limited to specific users, columns and rows) 3. View rights (limited to specific users, columns and rows)…
-
Adding system columns in the confirmation email?
Hi, I have two system columns: an auto generated number to represent order number and a created on timestamp. When I create the web form, I want these two fields to be added into the confirmation email so that when a user submits the form, they can see their order number as well as the timestamp. Is that at all possible?…
