-
Use Max function to return person's name?
Hi I want to use a formula that will return the highest value in column 2 is there a way to do this please
-
Issue with simple division formula
I have a sheet that pulls labor hours via cell linking. I want the neighboring cell to result in total hours / 4, but I am continually getting an #INVALID OPERATION error. In the below, I want CM App Hrs = 40. If I manually type 160 in CM Hrs, the formula works fine. All cells are Text/Number type (including the original…
-
COUNTIFS with greater than or equal to and less than or equal to date range
Hi, I'm trying to run a COUNTIFS on a Smartsheet that has a "Created Date" when a user submits a form. I want to count the number of submissions within a given timeframe, i.e., the month of January. I've tried the following formula: =COUNTIFS({In-Flight IFM Page Request - Created Date}, >=DATE(2022, 1, 1), {In-Flight IFM…
-
Hi - function to remove a flag with a checkbox
Hi All I am sure this will be simple for someone, however I can't find the right solution. I have a flag column which has the following formula to calculate and is very simple and works perfectly: =IF([Activity Start Date]@row <= TODAY(), 1, 0) However I would like this flag then to be cleared if one/or other of two…
-
Index Match Column formula returning wrong values sometimes
Hi All Thanks heaps for any advice. I have a sheet with a drop down of all my products. In the next cell i have an index match formula pulling the description of the product. It was working in the initial cell so made it a column formula. IT works for everything but as i add more rows the formulas seems to pulling wrong…
-
Can I get help on this formula? Not sure where I am getting it wrong.
I need this formula to be one value if Yes and the other Value if not Yes:
-
Conditional Formatting for highlighting rows if certain columns have data in them
Hi, I have an aging report in smartsheet and the last few columns are invoices that are past due certain time periods. If there is nothing past due, the cell in those columns are blank but there is still data in the row. I'd like to highlight the rows if these columns have any data in them. Is there a conditional…
-
I want to know how many rows have changed in the last 30days from a table.
So I have a sheet that is been updated. I would like to write a formula that shows if a particular column changed in the last 30days/ 60 days? Does anyone know to write this formula? Thank you
-
Index & Collect Using Date Range
Hello, I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work. In a new sheet, I want to return the value of a specific cell from a different sheet based on the date range (3 months prior to today) field. This is what I tried and it doesn't seem…
-
Calculated Status Indicator using task duration
Hi, I need to convert a formula that I used in MS Project (see below) to calculate task health status that uses the task duration. Has anyone created a similar formula that they could share? Purpose: Highlight tasks that are running late, based on the actual % complete compared to the “expected completion” using the task…