-
FORMULA WHEN THERE ARE MULTIPLE LINES IN A CELL
I have a sheet that has some rows that have multiple lines. I want to use the qty from each line for a summary formula. I have a formula that works when there are only one line in a row, but I get an error when there are multiple lines. Anyone know of a way to do this?
-
INTUIFACE API Intergration
Add compatibility for INTUIFACE user interface software to communicate with smartsheet via API on all platforms, inparticular IOS. Allow requests from origins, Player running on iOS, with the origin capacitor://localhost (capacitor://localhot) If you were using Intuiface on the web, the origin would be…
-
Merged: Automation Workflow - Action/Condition - Drag and Drop / Copy and Paste
This discussion has been merged.
-
Tracking Missing Submissions
Hi! Thank you for considering this problem, I am very new to Smartsheet. I have a form that I have 10 regions complete monthly. There is a due date for each month. I would like to generate a report of those of the 10 regions that did not submit a report monthly. How would I go about doing this? Thank you again!
-
CopyRow Automation Not Triggering
Hello Everybody, My team and I use the CopyRow Automation for project intake. Instead of using a form that feeds into a sheet, we manage two separate sheets: One for each of my team members (source sheet) One for the service team that performs the work (destination sheet) The CopyRow workflow is triggered when a field…
-
How Can I Automatically Remove Outdated Rows for Updated Project Data?
How can I automatically remove outdated data from Sheet A in my Smartsheet, which pulls project data (weeks remaining and timeline variance) from multiple project summary sheets? Whenever a project's data changes, Sheet A adds a new row with the updated information, but I want to ensure only the most recent data is shown…
-
Alert Automation- Populate Dynamic Column information by Clicking/Selecting instead of {{typing}}
Hi Smartsheet, Please make it simpler to populate columns in the Alert Someone automation. Clicking from a drop down would be much easier than having to type in the {{ }} and the column names. Thanks, Eric
-
Autopopulate Answers
Hello, I am creating a survey that asks about the use of different facilities and it is possible that some respondents will use the same facility for different things. Is there a way for someone to click that the responses for the first set of questions are the same for the next facility's questions? I am hoping it would…
-
Automation Not Running
Hello! I have an automation that is supposed to be running whenever an index-match returns a checkmark to change a cell value. However, this automation has not worked and I don't really understand why not. Any help?