Formulas

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…

Hello if something is typed in after 5:00pm, my date goes to the next day. How do i change this ?

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:…

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.

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…

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.

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…

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?

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…

Hello! I have a sheet with a formula to auto populate a checkbox is a status is entered. The checkbox formula works on the sheet, but when I created a report to pull the checkbox column, the column is empty and will not show the checkbox. Did I do something wrong? Is there a way to populate the column in the report and…