-
How can "successors()" just show direct successors?
Hi - I find a "successors" column useful. I can easily make a column with a column-formula of JOIN(SUCCESSORS(X@row),", ") - great. But if the successor is a parent row, I get not only the successor row shown but also all of the children of that row. Like this: I don't want to know that the tasks on lines 3 and 4 are…
-
Hi, I'm trying to reference a cell that contains a dollar amount based on a date range.
This is what I'm trying (unsuccessfully to accomplish) =IF([DATE SUBMITTED]@row >= DATE(2022, 12, 1), [DATE SUBMITTED]@row <= DATE(2022, 12, 28), "PO Amount Including Change Orders" Looking for the amount in "PO Amount Including Change Orders" to show up if the cell "Date Submitted" falls within the date span. Any ideas?…
-
Remove partial text at beginning of cell
Hello! I'm trying to use a formula to eliminate the first 4 characters at the beginning of a cell. Help would be greatly appreciated!
-
Formula for calculating today minus the case created date
Hi, I'm a new user here. What is the equivalent formula from google spreadsheet to smart sheet if for example, C2 is the cell with Case Created Date? =TODAY()-C2 I'm trying to show the actual case age without including the weekends and holidays. Thank you in advance for the one who will answer.
-
Formula Help - IRAAD Profile Data + IRAAD ID
Hello Smartsheet Community Just needing a little more formula help. I have an IRAAD that is being provisioned through a control center blueprint. In this IRAAD I need to add a column formula under the IRAAD Identifier Column. I need to create a unique identifier that takes the Business Partner Alias Profile Data under the…
-
NEED HELP WITH FORMULA: Status Based on Target End Date, Actual End Date and "At Risk" flag
So this is my current formula: =IF(OR([Task Name]@row = "Initiative/Program Overview", Program@row = "Initiative/Program Overview"), "", IF(AND(ISDATE([Actual End Date]@row), [Actual End Date]@row <= [Target End Date]@row), "Completed On Time", IF([Actual End Date]@row > [Target End Date]@row, "Completed Late",…
-
Join Ancestors
I am working my way through 'Writing Formulas in Smartsheet' module and I really don't understand the syntax of how the below would be written. Could someone provide an example of exactly how the formula would be written? Thank you!
-
Insert the month based on date
I'm trying to insert a formula to return the month i.e. January depending on a date. The formula I have inserted is =IF(MONTH([Start Date]@row) = 1, "January, IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 3, "March", IF(MONTH([Start Date]@row) = 4, "April", IF(MONTH([Start Date]@row) = 5, "May",…
-
Formula to flag a task if not completed before due date
I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column. Ideally I'd actually like to flag it if the due date is tomorrow or already…
-
Array Formula #UNPARSEABLE
I am trying to utilize an array formula in order to calculate a net "score" based on a combination of selected responses in a Smartsheet form. Essentially: Based on pre-assigned values (1, 2, or 3) for each selectable response, I'd like the form to auto-calculate the cumulative value based on the combination of responses…
