-
Split or Parse Formula
Hi All I am trying to spilt a multi select drop down column into two individual columns - I have tried several options but just cannot get them working =IF(ISERROR(FIND(",", [Survey Type]@row)), [Survey Type]@row, LEFT([Survey Type]@row, FIND(",", [Survey Type]@row) - 1)) =LEFT([Survey Type]@row, FIND(",", [Survey…
-
Trouble with IF statement and date format conversion
Hi all, I'm having a formula issue that I need human support for. [AI is failing to translate it properly]. Here's my scenario (I'm so close!): I have an orange text column [Delayed Result Date] that sometimes contains MM/YYYY format and other times MM/DD/YYYY format. I need to make it a (yellow) date column [Delayed…
-
Formula Order of Operations Problem
I am trying to use a formula with CHAR(10) between each missing asset item to build a nice list to use in a record search return automation. I am using one row for each employee with multiple uniform items in several columns. My formula does well until it finds an item in the formula sequence is not missing, then it quits…
-
Calculate totals across multiple project sheets , using another sheet to get the list of projects
Hello I have project request sheet which is used to track all projects that the LE team are asked to do. The LE team consists of 3 team members. As projects on the request sheet are approved, team members are allocated to the project. On the project sheet the project status is set to approved. I would like to know how to…
-
How do I pull data using cross-sheet reference and multiple criteria
Help! I have tried to get pull this data using many different combinations of formulas (using AI and searching through other posts.) Here is what I'm trying to do: I want an "X" to appear in the appropriate column when pulling from another sheet labeled "Roles" The Roles sheet has five different columns that I need to…
-
Form entry: Create new row for each checked checkbox in form
I have a form that uses checkboxes to accept user input. I want the form to create a new row for each checked item in the form. I do not want to rely on a third-party solution for this, as I am not part of the team that makes that type of budgetary decision, and it will unquestionably be denied. (Category "Formulas and…
-
Function for finding the # of days between two dates
Hello, I am trying to find a function in Smartsheet that will allow me to identify the number of days between two dates. In excel, this function would be DAYS(end_date, start_date), but I can't seem to find a similar function in Smartsheet. Suggestions? Thank you
-
Syntax with a mix of or, and, contains and not
Hello All, My formula is: =IF(OR([Box Shrubs#]@row >= 2, AND([Box Shrubs#]@row = 1, NOT(CONTAINS("hedge", [FN: Pruning]@row),1, ""))))) So basically, if the number at box shrubs is greater and equal to 2 then mark box; OR if box shrubs is equal to one AND the cell Fn: pruning does not contain hedge, then mark box I keep…
-
2 Approval workflows seem to be sending separate emails at same time
I created a workflow that if rejected the submitter is notified then I have a checkbox for them to "re-submit" which is a new workflow that also includes a reject message. What i have found is both workflows seem to be sending messages. Is there a way to 're-submit' into an approval workflow without having to create a new…
-
Formula error
This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NETWORKDAYS([Planned End]@row, TODAY())) Thanks, Freda
