-
Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
-
Developing existing formula
Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", [Post AFC Change Status]7 = "2. QA Rejected", [Post AFC Change Status]7 = "6. Returned by NR PM", ISBLANK([Post AFC Change…
-
How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?
I'm attempting to track the number of requests received and the months they were requested. What formula can return a Month name for a date (xx/xx/xx) e.g if I have 12/25/19 the formula will return December 2019. Please assist. Thanks
-
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.