-
How do i restore sheets to the correct workspace?
We 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 oldadmin@email.com". and the folders that used to have sheets now appear empty to all users who still look like they have access to the…
-
Conditional Formatting or Formula?
s 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 Function
Hello! 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 range isn't correct, but cannot figure out how it should be. Thanks for any help! =IF([Effort…
-
Getting value from Parent column
In 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". I was hoping to reference it by using =PARENT() Can someone show me how to do that? I have had no luck. =PARENT() provides a reference,…
-
Rules for rows generated via web form entries...
Good 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. I have 3 parent Territories: Canada, US, and Mexico. 2. I want each territory to have it's…
-
Automating Dependencies Between Tasks
I 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, Not started, In progress, Complete). When a task is marked as not applicable, I…
-
FORMULA - Estimated vs Actual Time
FORMULA 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 Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
Datamesh Cell linking not appearing for all cells in a column
I 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)
I 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 formula in the planned % complete column: =IF([Planned Finish]4 = TODAY(), 1,…
-
return a blank when #divide by zero
friends, is there a quick n easy way to return a blank in a cell instead of #divide by zero pls see screenshot. ta, Si.