Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Archived 2017 Posts
Discussion List
-
How to enable users to view entire sheet, but only edit rows assigned to themIn Archived 2017 PostsI want all the users in the dept to view the entire sheet, but only able to edit rows with their name in the "project owner" column. How can I do that? We use one sheet to list all projects in our dept. So we are adding and r…
-
Transfer/Move/Copy Rows from one sheet to another, and keep formulas..?In Archived 2017 PostsI need to transfer rows from one sheet to another that contain formulas. I know that the simple copy and move options just transfer over the values of the cells, but I'm really hoping that someone has found a clever way around this. We've …
-
Conditional Formatting for Kanban Card ViewIn Archived 2017 PostsWhen looking at items in Card view, conditional formatting is an option but you can't apply the formats to the card view itself. Is there a way to change the color of card based on conditional formatting? Current apply to rules only work …
-
Enhancement Request: Improvements for Contact List columns in FormsIn Archived 2017 PostsWhen adding a Contact List column to a Form, if no contacts are listed in the column properties, the field shows up as a simple text entry. If contacts are added in the column properties, the entry changes to a drop down. However, the dr…
-
EOMONTH formula requestIn Archived 2017 PostsI would really like to see the EOMONTH formula. There is a way to do that with the current formulas, but as an example of how long it is, here is what's needed for setting a due date to the end of the current month if there are more than 1…
-
Could a task be assigned to a group of contacts?In Archived 2017 PostsI would be interested in sending reminders and notifications to a group of people. I don't see helpful including more columns to do so as the table will be too long.
-
Need help with #Divide By Zero errorIn Archived 2017 PostsI am trying to calculate the average duration taken to complete a project for a date range. I get a “ #Divide By Zero “ error and would like to use IERROR function to get 0 when divided by 0 instead of the error message. Please see the for…
-
Nested IF Statement for Flagging DuplicatesIn Archived 2017 PostsHi, I am looking to create a nested IF statement that allows me to look at multiple columns for duplicates. It is only true if there is a duplicate in each of the columns. For Example: First Last Job Jeff …
-
Formula to automate Parent dateIn Archived 2017 PostsI can't seem to locate the formula that auto-fills a Parent date with the last date entered for a Child line item. It would be the same as the Start and End Date column parent cells, but those are system so I can't copy/paste the corr…
-
Gannt Chart - multiple milestones on the same rowIn Archived 2017 PostsI want to set up a recurring set of weekly meetings over a 3 year project on a single row. So far the only way I see to do this is to have a separate row for each meeting....painful. I can do a roll-up, but it graphically shows as a contin…
