-
MS Project Budget Reports and Smartsheet
At my organization we are currently trying to transition from MS Project to Smartsheet. Currently, using MS Project we are able to use a resource pool (every resource is added based on hourly rate, etc) and we are able to generate budget reports automatically. Is this feature something that is available on Smartsheet as…
-
Formulas
I would like to have a nest If / Then formula that is dependent on the %Complete Column. EX: =IF([% Complete]9 = 100%, "Complete", IF([% Complete]9 = 0%, "Not Started","Pending")) I am getting the #UNPARSEABLE error. Thanks in advance.
-
SUMIFS formula
I'm trying to create a formula that adds my second and third column if the fourth column says "LOST" , I want that same formula to subtract the second column from the first column if the fourth column says "KEPT". -My column titles are: Column1: total budget Column2: money allocated Column3: tentative remaining Column4:…
-
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?
-
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…
-
Sights and day prior information
Hi Team, Question - we have a sheet which is populated via a web form. We want to create a Sight that only shows the day prior's row. So, if today is 10/5/17, we want the sight to show the detail from 9/5/17 only. Can't figure out a way to do this. screen shot attached for explanation. Thanks, Kylie
-
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…
