-
Help with COUNTIF(S) formula to check for duplicates that meet multiple status criteria, and columns
Hi, I'm still new with Smartsheet and even newer with figuring out the syntax of formulas, and was wondering if someone can help me with a request Currently I have a COUNTIF formula to check a box if there is a duplicate number in the ID Number Column: =IF(COUNTIF([ID Number]:{ID Number], [ID Number@row)>1,1,0) How do I…
-
IF AND ISBLANK formula
I need my formula to read: IF the Comments Log Received is BLANK, AND the Approval Status = "All Comments Resolved" THEN calculate NETDAYS between Date Submitted and All Comments Resolved This is what I have come up with. However it fails. =IF(AND(ISBLANK([Comments Log Received]@row), ([Approval / Status]@row = "All…
-
How to make the date stay the exact date
Hello if something is typed in after 5:00pm, my date goes to the next day. How do i change this ?
-
COUNTA alternative in Smartsheet
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
-
Calculating Days
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Data doesn't match the data from Excel when replicating formulas
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to be a number of discrepencies with some of the data where it is out by a few thousand pounds or a couple of percentage…
-
How can I label rows based on their level 0 text?
I'm looking for a column formula that will apply the text from level 0 to all of its children, grandchildren, etc. My sheet has multiple level 0 rows.
-
Service log / mileage tracker
I am using a form which has an individual input the current mileage of a vehicle every time they use it. This would need serviced every x amount of miles. I am wanting to set up an automation that will email a specific person whenever it's time to service the vehicle. I guess right now I am trying to find a way to do this…
-
How to make tasks health status column more accessible by include color words
Hello, I am trying to make the health status column more accessible by including words to match the colors (e.g. 🟢 green, 🟡 yellow, 🔴 red). Does anyone know how to do this?
-
Revise Formula to include a but
My current formula in one column that is working out is the below: =IF(OR(CONTAINS("Term", [Column1]@row), [Column2]@row = 1), "Green", "Yellow") For the next column I need a revised formula to say "if the term is in column 1 and column 2 is check BUT Column 3 is checked then it will give me a red ball" What do I need to…
