-
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!
-
CONTAINS formula
Trying to get a formula to lookup a reference sheet to see if the ID contains the word BASE in it and return with a value SKUBASE if so and SKU if not. I feel like I'm close but just missing something. I had a formula where if I checked the box "add base" it would simply add the suffix BASE to the id however this is all…
-
IF Function not working for me
I'm referencing a Birth Date in a sheet and want to use the IF Function along with the Month Function to isolate the month of a person's birthday date. The DOB column is in DATE Format (i.e. 12/05/75). Some of the rows do not have any data populated in them, and I'm trying to return a blank (i.e. "") for those conditions.…
-
Index Match Function Help
Hi All I am using the following formula to pull over a contact from another sheet if the request id number columns are the same. It appears to work for some entries but others it is showing #NO MATCH. Both the columns containing a contact are set as contact list columns types. Can anyone help? =INDEX({Appendix B Approval…