-
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…
-
Automation Across Multiple Task Checklists in a Workspace
I have multiple task checklists to monitor so I need one weekly report that will show all the past due tasks from every checklist under the one Workspace. Currently, I'm adding the Automation to each checklist. Is it possible to just add it to the Workspace itself and run to capture from all the checklists?
-
Automations to move rows to another sheet is moving more than requested
Hello Smartsheet Community, I have created an automation to move rows over to another sheet when a certain phase and date are triggered. This automation is currently moving over those rows, but other rows in addition to the ones it is requesting. These other rows shouldn't be moved at all as the phase is not listed as one…
-
Create a new row when a cell is updated in a report
I have a Report that pulls from a source sheet. When the data in the Report is updated, I would like it to create a new copy of the row in the source sheet rather than updating the existing one. Currently, since the Report is directly linked to the source sheet, any changes made in the Report overwrite the cells in the…
-
NETWORKDAYS & Weekends with Notifications
I am using the below formula to try to stop notifications on weekends and holidays. My automation has a condition to check if this field has a check mark. If it does have a checkmark, it sends a notification. If it is unchecked it is supposed to not send notification but it appears to still be sending them on the weekends.…
-
Data mesh: Merging between sheets
I have 3 sheets: 2 of them have their own forms to collect data, and 1 master sheet. The 2 individual sheets have questions which are similar to each other and questions which are completely different (they are 2 forms of questionnaires). The master sheet is used to merge the answers of the similar questions and all other…
-
AppSheet - Image upload to cells crashed
Hi All, We have AppSheet integrated with Smartsheet as our User Interface in the field for use in inspections. We like AppSheet as it displays and presents data better, and uses Smartsheet's sheet as source. However, as of around Monday 1/September, we noticed that we no longer can "upload" images using AppSheet and save…
-
Question about automation to generate duration of each status
Can we get an automation to generate how long is the duration of the open, closed, and average days that each open status have been open for before a status changed? Also can we get an automated count of days that the item has been open or until the status changed to closed?
-
Can you have a bar graph widget, automatically update the source range
Hello, I was wondering if it was possible to have a bar graph widget update its source range update automatically? For example, I currently have a bar graph that shows data from April, May and June - the numbers within these do update as new data is added. When it's the end of September, the bar graph will need to show…
-
CLOSED 🧠Automations Team is Looking for Research Participants! 🧠
Hi Community members, Our Automations team is looking to better understand how you manage and make sense of the automation workflows behind your projects and processes. No preparation is needed — and if you're selected for a session, you’ll be compensated for your time. If you're interested, please fill out this form, and…