-
Are Hammock tasks still not supported?
Hi there: I'd like to Hammock (as in MS Project - (https://support.microsoft.com/en-us/kb/141733), that is, the ability to automatically adjust the duration of a task (start/end date) to the value of a cell in the same sheet. This is extremely useful to monitor Slacks between key tasks. As of 2015, it appeared not…
-
Creating a form with Multiple Logics
I have a very large worksheet - almost 80 columns wide. Of those, about 20 are formula "Only" columns where personnel will not enter data. I would love to use the same form, select from the drop down and the fields auto-populate. But I am getting this error. Is there a limit? Or is the error because I am selecting the same…
-
Can you validate an email address in a form by domain?
Hi, We have a web form with a place for a respondent to enter in an email address. We would like to restrict the field so that only domains from state government agencies can be entered into the form. Each agency has a distinct domain, and they would all have to be accepted for this to work. Is this possible?
-
Smartsheet keeps adding Start date when I add a row and not letting me change the date
Hello, I am having trouble with a project. I am trying to add a Child Task in a section of my plan, and each time I add a row, Smartsheet adds the Start Date automatically (the earliest date of that section...the Start of the Parent) and it will not let me set my own Start date for the Child Task (even if it is within the…
-
Attachments not working?
We are suddenly unable to attach files to sheets. Anyone else having the same issue. I'm guessing it is related to whatever is breaking people's reports, but I thought I would check to make sure we aren't the only ones.
-
New Row Formatting
Whenever I insert a new row into my sheet, it is automatically colored blue and I have to manually change it to "automatic" to clear the formatting. The main problem is that Smartsheet always adds ten blue rows to the bottom of my sheet. I can delete those rows or manually change them to clear background, but once I reopen…
-
How to have a report exclude certain items
Hi, I'm trying to build an action item report that only shows approved items that do not meet certain criteria. So in the smartsheet, there is a check box for a document attached and several columns for links to other places. I would like to have the report include only items that are marked as approved (a dropdown column)…
-
Sort by Parent Values Without Changing Order of Children Rows
I have multiple tasks each with multiple sub-tasks. The tasks and sub-tasks are not in alpha order, for example: Whether I leave the rows expanded or collapsed, when I sort the rows by task, it sorts the task and the sub-tasks, like so: However, now the sub-tasks are out of their correct logical order, e.g., analyze data…
-
Alerts not working
hey crew. So I am trying to notify customers when somthing in a certain cell in their row changes. So I created a column where I can put in email address of the customer. Then I made the alert that anytime that column changes that the customers email would be notifed. Well, I used my email as a test and when I chance the…
-
Helper columns to allow parent row data to be included in automation
Hello! I am trying to work on refining our automation in a project management tracker we have. Our parent row has the start and end date for the entire project. I am trying to create a helper column that would automatically count days to end of project for each project and repeat that number for each line of a project to…
