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
Archives for May 2017
Discussion List
-
How do i restore sheets to the correct workspace?In Archived 2017 PostsWe recently lost our admin and we had to transfer owner to a new admin. it worked great for most of the workspaces. however, we have 87 sheets in a new folder called "Transferred from [email protected]". and the folders that …
-
Conditional Formatting or Formula?In Archived 2017 Postss it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?
-
Number Range for Logic FunctionIn Archived 2017 PostsHello! I have a range of numbers I need to include in a logic function, specifically: < 3 = XS 4-8 = S 9-16= M 17-39= L >40= XL This is my logic string, and I've used a similar one in a previous sheet, but I know my number r…
-
Getting value from Parent columnIn Archived 2017 PostsIn the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". …
-
Rules for rows generated via web form entries...In Archived 2017 PostsGood day everyone, I'm looking to perform the following using a webforms. When a webform is populated and a specific dropdown choice is selected, in smart sheet I want that row to be relocated to a specific category. For example: 1. …
-
Automating Dependencies Between TasksIn Archived 2017 PostsI am using Smartsheet for as an event planning checklist. I have enabled the dependencies and predecessors features. I have also created a status column with the following four options each each task in the Smartsheet (Task not applicable,…
-
FORMULA - Estimated vs Actual TimeIn Archived 2017 PostsFORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF N…
-
Datamesh Cell linking not appearing for all cells in a columnIn Archived 2017 PostsI have a series of columns Datameshed using the Cell link option but when I go back to the target sheet, there are random cells that do not show cell linking even though there is content in that cell in the source sheet.
-
Calendar calculation (possible bug)In Archived 2017 PostsI am having difficulty with a calendar calculation that I use to calculate planned completion %. When dates have more than 30 days or when a non-working (holiday) is part of the month, the formula is not working as intended. Below is the …
-
return a blank when #divide by zeroIn Archived 2017 Postsfriends, is there a quick n easy way to return a blank in a cell instead of #divide by zero pls see screenshot. ta, Si.