-
How can I create a function that separates a string of words separated by commas into rows?
=JOIN(COLLECT([column1]:[column1], [column1]:[column1], ISTEXT(@cell), [column2]:[column2], =""), ", "). Right now, I have this function in my sheet summary to concatenate all strings that have text in column1 and has no text in column2. The output it gives me looks something like "task1, task2, task3, task4, task5, task6,…
-
Can I create a contact group of non-Smartsheet users for a distro list?
Hi, I'm looking to set up a contact group for an event sign-up sheet, but the audience is mostly non-Smartsheet account/license holders. I'm working on bulk uploading the list as a .csv file and developing the group now, but I'm wondering if everyone on the list will require a license to be able to access it and enter…
-
Creating a IF(AND(ISDATE formula to check a box
Hi All, I am trying to write a IF(AND(ISDATE formula to check a box I have read through several post but dont see and example of doing all three of these functions nested together. I get either unparsable or Invalid argument on my attempts. Goal: in my data set I dont care what the date is just that it is a date (anydate)…
-
Search function not always working on iOS
Hi everyone, I created some new spreadsheets today, and while I'm able to use the search function fine on the computer, when I search the same thing on the mobile app I get no results. I'm still able to search many other sheets on mobile, but not the new ones that I created in the last hour. Is there a fix for this?…
-
Multi-select fields with INDEX/MATCH (or COLLECT) with multiple values
Hello fellow Smartsheet users! I am running into unique problem and more importantly finding the way to do something within Smartsheet. A little background. I build a request intake/workflow management tool for my Marketing department at a global organization. Users make Design, Content, Web, and Video requests through…
-
can forms have totals?
I want to add to a form a section that asks people for amounts and then totals it, is that possible? something like: blue widgets needed - # red widgets needed - # green widgets needed - # Total widgets = # blue+# red+# green
-
System deleted an automation?
We had an automation set up on a sheet to send a notification to a Teams channel when there are rows added via a form user. This morning one of my colleagues got an email from system.smartsheet.com stating the automation was disabled because one or more blocks in the workflow was invalid. We opened the Automation menu in…
-
Does Smartsheet forms have the equivalent functionality as MS Forms to jump to end of form?
Hello, I'm using conditional formatting on a Smartsheet form to vary the subsequent questions. However, there doesn't seem to be the same functionality as MS Forms, which allows you to use branching (aka conditional logic) to jump to the end of the form. I'm wondering how this can be achieved, if at all?
-
Generate documents from parent and children rows
Is it possible to generate one document from multiple rows? Best example I can think of would be an itemized order with multiple items in the order - how can you list all order items from that parent row (order number) with the item ordered [qty, price, detail information] on the children rows? Having columns to fill on…
-
Subtracting Dates - Smartsheet is rounding date/time up
I am trying to subtract two dates to get the duration of time something stayed within a phase. Currently we are trying to use "CreatedDate," the auto-generated field as the "start" and another date field as the "finish", let's call it "Date entered Triage". The formula [Date Entered Triage] - [Created Date] works great for…
