-
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",…
-
Look Up Attachment from a source sheet to another Sheet Using Datamesh, Formulas etc.
Hi Smartsheet Experts, I have attachments that I want to lookup or transfer from a source sheet to another sheet. I have tried to do it in the Datamesh but I can't find the attachment as a column. Is there a work around or Smartsheet Apps/Addons that can help me to that? Can I also use third party app like zapier and like?…