-
Inventory Status: Reordered (How do I do it?)
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
-
Removing Condition if the Value is blank
I have a formula that shows the Status of a milestone and it currently reads the due date (Finish) and automatically updates to off track if the due date has passed and the status if not in at risk or completed. However, I cant seem to get the formula to the point where it will not mark the milestone as off track if there…
-
Is anyone else having trouble with the Today function?
Hello, The Today function is not working when included in a simple IF statement. It was actually working a while ago but now it is not working. I tested it out by simply trying =IF(Cell@232="2",=Today(),"") but it would spit out #INVALID OPERATION. I have even tried =IF(Cell@232="2",Today(),"") but it would spit out…
-
Possible to insert today's date (dynamically) as Form default using URL Query String
Hello - I need to find a way to have a Date field default to the current date on a Form. (I can't use the systen-date field, as user needs to be able to override 'todays Date' if necessary) Unfortunately, selecting the obvious Date field-type default value to 'Today' .... locks in, literally, today's date - the date the…
-
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
-
Index/Match
I have a smartsheet that has a column for "State" and then a column for "Territory". How do I write a function that if a row within column "State" equals say "TX" than the column for "Territory" within the same row = "West". I would need to do this for all states broken into 4 or 5 territories.
-
how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?
Thank you for your time. I cant find the answer in the documentation or forum. So I am asking. a. How do I reference a single cell in an external sheet? b. Can I reference a cell by row number and column number? c. Is there a way to make this dynamic? using the ' =ExampleCell1 ' syntax is for the current sheet. How would I…
-
Keeping track of dates
I want the time a specific cell is edited to be automatically placed in a cell. I don't want to use the column setting because that updates when any cell in the row updates and not just the one I want. Is there a way to do this?
-
#INVALID DATA TYPE Error
I am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added later in the project, so there will often be blanks. My formula is below: Adding an IFERROR avoids the error message, but I…
