-
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.…
-
Sheet count
I have an individual account which allows me 10 sheets. If I decided to delete a sheet after use will that restore 1 back to my remaining sheets???
-
Identify all reports using Data Field
I need to change column header names on a sheet which is going to break reports. How can I identify all locations that the data field is used.......reports, metric, etc.?
-
Full year calendar - accounting month/quarter end
Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every quarter. I would like to see this in a calendar view Any suggestions on how to build this? ie: Formula for the 'due date'…
-
Reload does not ask to save changes!!!!! All lost
I just made a heap of changes to a sheet then had to reload as this included copying a row from another sheet I had open n another window. However, when I reloaded it lost all the changes as I had not saved not did it ask me if I wanted to save as part of the reload. Let's do it all again!