-
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…
-
Copy PARENT cell data to CHILD CELL without deleting DATAMESH field links.
Ok, I have a challenge with formulas and data being overwritten. I am trying to create a FILTER for my procurement teams to use. I ONLY want to show items where the PROCUREMENT COUNTRY is "CHINA". When I create that filter the CHILD rows do not show because the PROCUREMENT COUNTRY is "BLANK". So I need to copy the PARENT…
-
SUM formula
Hi. I'm trying to sum cells in a sheet with functions. It returns with 0 instead of the correct number. What is the workaround for this?