-
Can I add a formula to a drop down list cell?
I currently have drop down list that contains, "Not Started", "In Progress", and "Complete". What I would like to do is add a formula that automatically changes the drop down list from "Not Started" to "In Progress" if the Duration cell has been changed from 0% to anything non-zero. Is it possible to add a formula to a…
-
Formulas
I have a drop down text for my second column, I would like to insert a formula that when shipped is selected from the drop down, that it auto checks the check box in column 4 for complete. I have looked through all formula help sheets and can't seem to find this one. Is this even possible? If no, does anyone have any ideas?
-
Conditional Formatting For 11 Months From a Date
Hi Everyone, Thanks in advance for the help. Here is what I'm trying to accomplish. A service is sold on a specific date. We want a "timer" to start that will highlight the row yellow when it's 2 months from expiring. We want to highlight any row within the 10 month window from start date to be green & dates beyond 365…
-
Formula to return Parent name of child?
I'm trying to figure out how to return the name of a child's Parent. Example: Parent 1 * Child 1 * Child 2 * Child 3 Parent 2 * Child 4 * Child 5 In the above, I would love to have a column on Row Child 1 that automatically returns "Parent 1" and for Child 4 returns "Parent 2". Is there a way to have a formula function…
-
Formula to move a row to another sheet?
Good morning, I'm hoping I can formulate a column so that if the checkbox is checked, it will move that row to another specified sheet. Can this be done? If column A is checked, move to Sheet B is the basics, but formulas always mess with me. Blessings, Loann
-
Feature Request - Auto format for ranges
It would be extremely convenient if we could set our autoformatting rules for a Row, a range, or even the whole sheet, instead of just one column at a time as is the current configuration. EXAMPLE: I have 15 columns that I would like to apply the same 6 formatting rules to. Currently, that means that I have to define 90…
-
Nested IF statement for RYGB only works in one row
Has anyone come across a scenario where your nested IF statements work perfectly on one row, but when dragged to other rows don't apply the conditions correctly? I've added the following statement to row 47 of my sheet: =IF([Percentage Complete]47 = 100, "Blue", IF([Percentage Complete]47 < 33, "Red", IF([Percentage…
-
Workflows for Alerts
I've been asked to come up with a way for smartsheet to send an automatic reminder to "Assignee" two days before the target date. This is no big deal and actually very simple to set up; however, the second part is "if the date completed field is empty and equal to or greater than the target date". I attempted to do this…
-
Date Formula
Hi I am trying to calculate a date formula but having not luck! I am wanting a main date in my sheet, to trigger dates in other parts of the sheet but cant seem to find a formula which works. I also need to add days into the formula; eg. Project Start Date + 30 days Can someone help please, unsure where I'm going wrong.…
-
#unparsable error on IF/AND statement
Can anybody see the issue with this formula? I've counted and there are 8 open/8 closed parentheses, and two criteria for each of the IF(AND( statements =IF(ProdScore2/HrsWorked2 >= 4.4, "Outstanding", IF(AND(ProdScore2/HrsWorked2 <= 4.3,ProdScore2/HrsWorked2 >=3.8 , "Very Strong", IF(AND(ProdScore2/HrsWorked2 <= 3.7,…