-
Reports sort dropdown columns differently than a regular sheet
I have a sheet with a dropdown column for priority: High, Medium, Low. My sheet sorts them according to the order specified: High, Medium, Low. However, my report sorts them alphabetically: High, Low, Medium. Am I doing something wrong?
-
Contact List Drop Downs
Hi all, We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-down and select John Doe as the main contact, but User B can't even see John Doe as an…
-
Either/Or Dependencies?
I want to be able to use a dependency like "either/or" instead of "and" ie: Task 3 can start after either Task 1 or Task 2 is finished, but does not require both tasks to be done. Is this possible?
-
Drop-down list
I have a drop-down list of names on my sheet. I need to remove one of the names and add a new name, but I want to keep the list in alphabetical order. I can't find a way to re-order the names in the dialog box where I add the new name. Does this mean I have to go back, delete all, and then re-enter the names, placing the…
-
Re: Task Alerts
I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then included the following columns in my sheet so; * a date column for when activity is due…
-
What does "Insert Key" mean? What is a Key in a row?
I apologize in advance if this is a really basic question ... totally new to SmartSheet and I tried searching for this but to no avail. When I insert a row in a sheet, the right-click menu gives me two Insert choices: Insert Above (Insert Key) Insert Below Why does the Insert Above indicate "Insert Key" and what does this…
-
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…
-
Do not want Cells with "N/A" figured in my formula
=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started yet how do you exclude the cell with the "N/A" value in it from being calculated?
-
#Unparseable error
I'm using the system to monitor and report progress to our client. We do surveys on their sites and perform installations. On top of the sheet, I have locked 6 lines that I use for summaries of the totals with simple countif statements. Any ideas on why?
-
Force choice between columns
I tried searching the boards, but not sure that I'm asking the question the right way. Essentially, I'm looking to know the following: Within the Smartsheet worksheet, I have two columns both set up in a checkbox format. I'd like to restrict my users from checking both accidentally as it should be an either/or scenario.…