-
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…
-
How to count multiple values in a cell within a range?
I am trying to figure out a formula where I can count 1 row more than once in a COUNTIF formula based on what it contains. For example, I have a column that includes multiple values, separated by commas. I'd like to be able to count the total number of commas within that cell. For example, if a cell has three commas - it…
-
Asset Management - Best Practice
Hello Smart People - I’m building a simple asset management solution. I want to track assets as they move between locations using barcode scans only. I have a “live” sheet that has the current locations, updated as each asset is scanned into a new location. Each asset is only listed once here. I then have an “archive”…
-
How to set the start date on a given day of week after predecessor completes
If I have a task that can only happen on a Tuesday (e.g. that's when an approval committee meets), and all the predecessors are scheduled to complete the previous Thursday, how do I schedule the task to start on the first Tuesday after the predecessor completes?
-
Calculating Monthly Revenue
I would like to sum monthly revenue estimates of projects on our schedule sheets. We have several projects that straddle different months, this IS where it gets tricky. Is it possible to build a formula that looks at a project and if the Start/End date straddles a month, it then calculates how many working days in each…