-
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?…
-
How do I make a Smartsheet that keeps track of initials
I'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many times people completed certain tasks.
-
IF Function (Displays 0.00 instead of a blank when using "")
I have a formula that is properly calculating Years (Age) for a person's age if the Date of Birth (DOB) is populated, but is calculating & showing 0.00 for when the DOB field is empty/not-populated. I was hoping to just have that filed appear blank without a zero value. Here's what I'm using for the formula:…
-
Aging & Duration
I have a tracker set up in Smartsheet to log request tickets. I want to calculate the Age of the ticket based on [Today's Date] - [Initiated Date] unless the ticket [Status] is Completed or Cancelled, and then I'd like to calculate the Duration between the [Resolution Date] - [Initiated Date]. I've tried so many variations…
-
IF Function
Overview: Trying to calculate the years of service for an employee sheet that contains two columns: DOH = Date of Hire DOT = Date of Termination (Note: most values in this field are blank) Unable to figure out how to use the IF function when I'm comparing a Date of Termination (DOT) field that is populated to allow the if…
-
Compare two cell values in the same column
Hi all! I have a column of case numbers and I want the cells to turn red/have a flag or some other indicators if there is a duplicate (so the same case number). Is there a formula for this? I have seen a lot of formulas for comparing cell values but only if they are in different columns. Thanks!