-
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…
-
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…
-
Add Dynamic Reference in Formula
Hi, I'm creating a summary sheet, I have a few sheets with the same columns, and I want to add COUNTIF formulas to the summary sheet, I'd like to know if there's any way that the Reference should be a dynamic option, so if a user chooses on the Reference sheet from a dropdown column: Sheet 1, the formulas knows to use…
-
How Can I Create a "Stamp" of An Original Value?
Hi - I'm trying to create a rule/process whereby every time a row gets added (not changed), another cell gets "stamped" with the value. This is so I can have the stamped column as a reference of the Original value. In my scenario, it's a Total. So a row will get added, and in that row is a Total Column. I want to create a…