-
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…
-
How can I edit the result of a VLookUp or Join(Collect) Function?
Hi Everyone, I'm currently trying to reference cell values from one sheet to another. The values in the so-called "Database Sheet" will always remain the same. The main sheet will need to reference the values in the Database Sheet through the use of a Join(Collect) Function or VLookUp within the main sheet. Fortunately,…
-
Both reference ranges in a column formula are not globally updating? Any advice?
Hello All, I have edited a column in my template with a new formula. This column NOW has a formula that pulls in data from a reference sheet (metadata sheet). I have tested this out through a provisioning test, and it works! I Love it! This is a screen shot from my template sheet. =INDEX({Metadata Range 1}, MATCH("Project…