-
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…
-
Trying to anchor formula to specific row
Hi, I have entered this and it works: =IF(FIND([SOP Required Group]1, [SOP Required Group]@row) > 0, "Y", "N") but if I want to anchor to Row 1, I get an #unparseable error: =IF(FIND(SOP Required Group1, [SOP Required Group]@row) > 0, "Y", "N") What am I missing?
-
Join/Collect across sheets
Hello, I think I am really close with my formula, but still getting an unparseable error. =JOIN([Freelancer's name]@row:{Feedback Range}, COLLECT({Feedback Range}, {Audition Status Range}, [Audition Status]@row), "'s ") I have a source sheet (Feedback) that contains 3 different feedback text, for three different Audition…
-
Automation notification or email not coming through
Hi! I wanted to have an automation notification set up that when "form uploaded" is checked, it notifies the person in the "manager" cell. I've tried to adjust my automation two different ways, see screenshots below. Simple enough, but it isn't going through.