-
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…
-
Email validation for Forms or Workflow conditions
Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…