-
Formula or method(s) for identifying project tasks that can be started
I have a project sheet with dependencies enabled. I am trying to build a report that shows tasks that can be started because all predecessor tasks have been completed (e.g., marked as 100% complete). I have some ideas on how this can be accomplished, but wanted input from the community here, in case this problem has…
-
Need Help with Approaching Due Date Formula
I have an Approaching Due Date column with the Star checkbox and I want to create a formula that will show the Star if today is between 7 working days in advance of the End Date and the End Date, and the Status is NOT Complete. I also have a column for Past Due with a Red Flag checkbox. I want the Approaching Due Date…
-
IF formula #Unparseable error
Hello! I have set up the following IF formula that triggers actions based on risk category, but it is returning an #Unparseable error. I would appreciate any help anyone can provide. Thanks! =IF(CATEGORY@row = “Resource”, “Escalate”, “Do not escalate”)
-
IF Statement between Ranges
Hello, I am not sure what i am doing wrong in the formula =IF([Current Risk Score]@row < 15, "36 Months", IF([Current Risk Score]@row > 70, "3 Months", IF(AND([Current Risk Score]@row > 16, [Current Risk Score]@row < 29, "12 Months", IF(AND([Current Risk Score]@row > 30, [Current Risk Score]@row < 50, "6 Months"))))))…
-
Editing Formula
Hi there, I have this formula in the Schedule Heath column (picture of sheet listed below). Currently, the default value for cells in the Schedule Health is Red. I want to change its gigantic formula so if the End date is blank, the schedule health stays blank too (instead of red). Appreciate your suggestions. Thank you!
-
Automation Error
Not sure if this is the right place for an automation error or not. I have previously asked about returning a value once (not sure if my link would work for everyone or not). I was able to get it to work with a metrics sheet, a helper column, and a copy rows automation. However, the ID I used for that one, is only valid…
-
Arrange meetings from within SmartSheet
Hello, Is it possible to arrange a meeting from within SmartSheet - instead of using Outlook. That way one could send a meeting invitation where the SmartSheet document would be an attachment similar to Outlook process. Thanks, Sigurdur
-
Notification When a Date Changes
I am trying to work with formulas and notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sent the reminder. In the picture above, somebody will manually enter the Due Diligence Date. The Site Development and Hard…
-
=SUMIF for calculating budget on multiple rows.
Hi! I have a sheet that breaks down different accounts. Some line items within an account will have a cost associated with it. I want to be able to calculate the cost of those line items per account. If I do a simple =SUM formula, it gets confused as things are added, changed, filtered etc. I tried to write a =SUMIF and it…
