-
Creating a Sheet from Excel
I pulled an Excel file into a sheet to create a new smartsheet. after doing so, I made a report for myself to help analyze the data. The sheet no longer has any of the information that I inputted form the original Excel file, but I can still change the parameters in my report. Has anyone had this issue?
-
Email notification
I'm working with a sheet that is somewhat critical to the leadership of my org. My sheet requires updates from many people. I've managed to setup the reminders to the group for updates but I would like to know when they do so. Is it possable that anytime a update to my sheet is made, I receive a email with update to…
-
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…
