-
Apply Date parameter in different rows
Hello, I need to use the same date in different rows but using a formule. I built a sheet named "Meses" with the dates like below: to use the same dates in different rows instead of changing by hand. However it is not working because it is returning 0 in the formule below (for example): =SUMIFS({Project_Product Release…
-
Help with nested IF for distinguishing between 4 and 5 digit numbers in a cell
Hello, We have a formula in this sheet that currently distinguishes between multiple PO#s in the PO column and separates them into individual columns when there's more than 1. In anticipation of using 5 digit POs alongside the standard 4 digits we currently use, we're having difficulty setting up a something like a nested…
-
Why doesn't my formula work?
I have created a sheet using the Risk Assessment Matrix template as a guide. I want a formula that auto populates the risk rating based on likelihood and severity. =IF(AND(OR(Likelihood@row = "Possible", Likelihood@row = "Unlikely", Likelihood@row = "Rare"), Severity@row = "Minimal", Severity@row = "Minor"), "Low",…
-
Status change formula using IF function
I have a status column that I would like to set up a formula in to do two things a) Change status to "Needs Update" when a date in a date column is reached b) Change status to "Prequalified" when three checkbox columns are all chacked Here is the formula I have so far: =IF([Expiration Date]@row = TODAY(), "Needs Update",…
-
How can I do an IF Statement with Years
Hello, I have been trying to find an answer to my problem through the forums but have been unable to solve it myself currently. What I am trying to do is set up a formula that tells us when employees get vacation days. How our company currently works is as follows: If employee has been here 1 year, they get 5 days vacation…
-
IF Formula using date cells with formulas
Hi, Im new in smartsheet and im currently trying to compare a Task Limit Date (for completion) with Today's date to determine if the Task is Late or On track My formula is the following: =IF(Limitdate@row > TODAY(), "Late", "On Track") As my Task Limit Date was initially documented in quarters of every year, for example;…
-
How can use the Countifs function with the Today function in the formula?
Hello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <=…
-
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
-
IF statement (Inventory status updated from "order needed" to "reordered")
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…
-
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…
