-
Automatic Linear Percentage Complete Formula
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
Eliminating "0" from a cell when it is returned in a formula
Hi, In order to get some downstream formulas to work, I am trying to remove "0" from my calculation cells if "0" is the result. Based on the reported success with the formula other Community posts, I have tried to use this approach: =IF(original formula > 0, original formula) ...by using this sheet-specific formula:…
-
Formula for Quantifying Importance based on Priority Level and Due Date
Hello, I am looking to create a formula to help prioritizing tasks based on importance and due date. I assigned a value for the priority level as: =SUM(IF(Priority@row = "High", 6, (IF(Priority@row = "Medium", 4, (IF(Priority@row = "Low", 2)))))) + ______ The second part of the equation I need to have based on due date. I…
-
Cross Sheet References
Hi, We have a data entry sheet where data is entered via forms and an overview sheet, that is an overview sheet with cross sheet references. Using sumif formulas, however this only works when you open and save the overview sheet, you can't get live data unless you open and save the overview. Any workaround to this?
-
Help with SUMIF Formula
Hey Community, I need some assistance with a SUMIF formula. I am trying to say, Multiply Column 1 by Column 2 IF Column 1 is greater than 1, if not, leave blank. I have tried several different ways but all keep coming back #UNPARSEABLE. Would appreciate some help with this. Thank you in advance!
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?
-
Does Smartsheet have a Debug tool?
Having trouble getting the combination of INDEX(COLLECT)) functions to return the correct data. Is there a "Debug" tool similar to that available in Visual Basic that allows you to step through the formula? Thanks in advance.
-
Invalid operation with IF Formulas
Hello Smartsheet Community, I am struggling to figure out this IF Statement. Smartsheet tells me this is a Invalid Operation =IF([Use Case Development % Complete]@row = 1, "Completed", IF([Use Case Development % Complete]@row = <1, "In progress", IF([Use Case Development % Complete]@row = 0, "Not Started"))) What am I…
-
VLOOKUP with IF and IFERROR Formula
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull in Survey Status “Complete”, otherwise (IFERROR) "N/A". This is the new formula I…
-
Using a formula for the colored lights symbols
Hello! I'm fairly new to working in smartsheets, and I wanted to try and use the formula for updating the status of a task based on a dropdown box. I used the following formula and I am getting a "#unparseable." Am I missing something obvious? This is the formula I am using: =IF([Production Progress]@row = "Not Started",…