-
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…
-
Adding Workdays to a Formula
Hi SmartPeople - I am trying to create a formula that adds "work days" to a date. Example: I have a "Date Reported" column and a "Date Due" column. The "Date Due" column is a formula based column that should add a specific number of days (either 5, 10, or 20) based on a given priority in the "Priority" column. However,…
