-
Due date PRIOR to weekend or holiday
I have a one date upon which all other due dates are calculated. We have holidays set up for the account. I need the due dates to fall on the weekday PRIOR to the due date if it is a weekend or holiday. It appears the Workday and Networkday functions fall on the following week day, which doesn't work for me. This formula…
-
Event Registration with Form & Summary
I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next…
-
splitting text into multiple rows
Hi there, I am using smartsheet for text analysis and would like to split a cell into separate rows using a return or a full stop as the separator. Any ideas?
-
Calendar calculation (possible bug)
I am having difficulty with a calendar calculation that I use to calculate planned completion %. When dates have more than 30 days or when a non-working (holiday) is part of the month, the formula is not working as intended. Below is the formula in the planned % complete column: =IF([Planned Finish]4 = TODAY(), 1,…
-
Countif a value AND Completed Date not Blank
Struggling with the right equation. Completed Date Column has no end range (rows can continue to be added at anytime via a form). Size Column has many different sizes 32, 40, 50, 60, 72, 80, 100, 106 that can be in the column. In additional columns I have a column for each size. I want to count how many size 32 I have IF…
-
Formulas
I would like to have a nest If / Then formula that is dependent on the %Complete Column. EX: =IF([% Complete]9 = 100%, "Complete", IF([% Complete]9 = 0%, "Not Started","Pending")) I am getting the #UNPARSEABLE error. Thanks in advance.
-
Conditional Formatting or Formula?
s it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?
-
Getting value from Parent column
In the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". I was hoping to reference it by using =PARENT() Can someone show me how to do that? I have had no luck. =PARENT() provides a reference,…
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…
