-
Two dates between Now and +7 Days
Hi I am trying to return a count of dates between two dates that will move based on todays date, I have tried umpteen different approaches but cannot get the sheet to return a valid answer. =COUNTIF(MigrationDate1:MigrationDate3, >TODAY() <= TODAY(+7)) 19/08/20 19/08/20 05/08/20 The answer it returns is 3. I would have…
-
Need help with RYG status formula.
Hi, I am using this formula currently to change a harvey ball based on dates. It is currently working, but I am modifying my sheet to include rows that I want to ignore for now, meaning that some date fields will be blank. I would like for the formula to return no harvey ball color when there are no dates in the cells to…
-
INDEX & MATCH where the MATCH is based on a multi select dropdown?
Hi - I have been trying to work this out, read through a number of threads, but, cant see this question directly answered. Scenario: I have 1 sheet that has a list of tools and another sheet which is used to record who those tools have been handed out to by using a multi select dropsown column. What I would like to be able…
-
Does Smartsheet allow the calculation of IRR?
I have found a key element of Program Management that needs solution in the Smartsheet platform. The calculation for IRR is critical component and not available as general function. As you may know, this simple one varying net cash flow typical program. Does anyone calculating real-life program can share with me?.
-
SUM(CHILDREN)
I have a formula that is using VLOOKUP to pull an item's price from the Price List sheet. It need to account for 3 possibilities: The product is in our database - in which case the VLOOKUP work The product isn't in our database - in which case it says there is no price in the system The line is a PARENT row and doesn't…
-
Pasting Data Set
Hi, I have a large data set that I paste into Smartsheet from excel for a Dashboard to populate. When I paste some of the data in that's in 1 cell in excel Smartsheet is splitting it across multiple columns meaning I manually have to amend the data for those rows which is very time consuming.
-
=if(or(isblank( issue
Viewed a number of threads and cannot seem to understand why I am getting unparseable? =IF(OR(ISBLANK(Finish1), Start1 < Finish1, "OK", "Start>Finish")) Help appreciated.
-
Multiple Vlookups from Different sheets
Hello everyone im trying to do multiple vlookups from different sheets, but im having #unparseable as an output. =IFERROR(VLOOKUP([HELPER 1]1, {LIR-whse1 Range 2}, 22, false),iferror(VLOOKUP([HELPER 1]1), {LIR-whse2 Range 3}, 22, false),"no match")) sheet1: {LIR-whse1 Range 2} sheet2: {LIR-whse2 Range 3} thank you
-
Multiple if / and / istext
Hello Everyone I am finding a way to fit a new argument this is my current formula: =IF(ISBLANK([Logistics Validation]1), "New", IF([Logistics Validation]1 = "invalid", "Closed", IF(AND(ISTEXT([Logistics Personnel - Assigned]1), [Logistics Validation]1 = "Valid"), "In-Progress"))) need to add this arguments, logistics…
-
How do I create a formula to activate a flag if a column has not been changed?
I want to be able to send an automatic update request when people fail to add updates to a text column (Called Updates). Currently, this doesn't seem possible. But I thought of a workaround that may work if someone could point me in the direction of writing a formula. I thought of having a flag column that will go up if…