-
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,…
-
Enhancement Request: LOOKUP argument for default value
I would like to request an additional argument (optional) for the LOOKUP function for a return value when no match is found. The MATCH() function could use this as well. I know having two optional arguments may be a pain. Throwing an error would also provide functionality, but I don't want to suggest using an error message…
-
Two SUMIF Questions: NOT and Children
=SUMIF(CHILDREN(Status3), "Rejected", CHILDREN()) 1) How do you use the NOT logical expression in a SUMIF statement to add values together only in those rows whose value does NOT have a certain string? For example, add all of the cost values together unless the status says "Rejected". 2) For the condition test range of the…
-
Smartsheet Budget Formulas
Hi, I would like to know the formula for the due date of every month to calculate the receivables and Payables. For example, I have the data with amounts and due date of the payment. How can I input the formula, grab the amounts by the due date of every month. Please let me know.
-
Countifs formula using or
Hello. I am trying to count the RYG ball (in this case red) for each team. One of our teams is comprised of three sub-teams, so I need for it to be counted if any of those show a red ball. How do I create or for the Team section of this formula? =COUNTIFS([Overall KPO Status]:[Overall KPO Status], "Red", Team:Team,…
-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
-
Show days left in Smartsheet
Hi, I'm total newbie in Excel functions. I want to show the days left from a date. So I have the follow formula which works: =[Column-Name]23 - TODAY() This only works for row 23 of course. But I just want the current row in it so I can use the same formula in every row. So In row 8 it uses the date from row 8, in row 9…