Best Of
Re: Really simple If statement - value if true doesnt work if value if false is ""
I have now lodged a bug ticket and I have found a workaround - by creating a column to do the hierarchy count and then running the if statement on that column. very weird.
Jacinta
Re: Pre-Populate Form with Entire Field from Sheet
You will need to SUBSTITUTE spaces with "%20" (note the %20 in the the field name where the space would be).
+ "&Vendor%20Company=" + SUBSTITUTE([Vendor Company]@row, " ", "%20)
Paul Newcome
Re: Multiple actions on status complete workflow
@Chadd have you tried a single workflow? You should be able to combine the three steps, just think through the logical order. (If you copy the row somewhere else, you shouldn't expect a subsequent update to the original to show up in the copied row!!)
dm
Dale Murphy
Re: Multiple actions on status complete workflow
@Chadd You would have to ask the SmartSheet engineers that question ;)
Looking back, when I have needed to do what I think you are doing, I trigger the lock and/or copy workflow on the contents of that date field you are filling. So when that date field first is filled (i.e., is no longer blank) the copy and lock workflow run.
Make sense?
dm
Dale Murphy
Re: How to fix my #Boolean Expected Error
You should be able to just convert it into a text string by adding
+ ""
to the end.
=COUNTIF(Done:Done, 1) / (COUNTIFS(Done:Done, 0, Tasks:Tasks, NOT(ISBLANK(@cell))) + (COUNTIF(Done:Done, 1))) + ""
Paul Newcome
Re: Combining IF and IF AND Formulas
Quick note about nested IFs...
For the formula to move to the second IF, the first must be false. For it to move to the third, the first and second must be false, so on and so forth.
Leveraging that (and assuming you won't have a negative %), you can actually simplify it a little bit by getting rid of the AND function along with the greater than or equal to .01 portion.
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row < 1, "In Progress", "Complete"))
It doesn't make a huge difference in this specific case, but it is something to keep in mind when you start stacking more and more IFs on.
Paul Newcome
Re: Parsing Text into Child Rows
Hi @ARosen
There currently isn't a formula in Smartsheet that can automatically parse out pieces of data from a text string and turn those into additional rows. You would need to manually create the additional child rows and copy/paste in the data (to evaluate how many rows are needed, and where the hierarchy should be placed).
If you're just looking to surface rows that have linked issues, you could create a Filter looking at that third column.
Another option would be to have a multi-select column next to the text column, then use the SUBSTITUTE Function to replace any instance of a comma with CHAR(10) (a line break) so you have separate ORs listed, just as numbers:
=SUBSTITUTE(SUBSTITUTE([Column 3]@row, ",", CHAR(10)), "Includes", "")
Cheers,
Genevieve
Genevieve P.
Re: Multiple (unwanted) dates entered from an action from a single workflow ?
I had the same issue...
I'm assuming you have a "Save response in: Most Recent Approval" or somewhere else that is the same for each approval workflow (be sure to take a screen shot of everything, helps sort out the little things).
Think of the back end of the Request an Approval box as it's own separate workflow. It's condition is When {{Most Recent Approval}} changes to "Approved" or Declined"... After they approve it in one workflow and that cell udpates, the Approved or Declined branches in the other workflows trigger as well, even if the conditions before that approval chain aren't met (in your case, when it's Not Applic. or whatever it is we can't see)...
I worked around this by essentially having the same condition on the front and back end of all approval workflows. So if your trigger is "When ORC Task changes to Not Applic.", create a condition on both the approved and declined branches "Where ORC Task is one of Not Applic.".
Here's an example from one of mine. Without those conditions, when stage approvals were being denied or approved in other instances, they were getting the responses from other approval requests as well...
Hope this helps.
crittcg
Re: Can I copy gantt lines from one sheet to another and retain structure?
One solution would be to match the lines in the file you want to copy to where they will be when pasted. For example, if row 1 of the original is to be pasted onto row 6, add 5 blank rows above row 1.
Then you can simply copy and paste the predecessor column and the rows will match.
This is not elegant, but it saves time.
Christian G.
Re: Generate Document Workflow has become invalid
I have had this problem a few times. I did some digging around since it was only once in a while it would happen. In our case, we have a form where it would generate the document and route it through DocuSign. Apparently, one of the fields on the form (an email address) was entered incorrectly which disabled the entire workflow. I went in and corrected the email address, refreshed the workflow and it resolved the issue... until another invalid email address was entered in again.
CaraB
