-
x-sheet reference - trigger for automations
Trying to trigger an automation that is not working b/c the source column is a x-sheet reference value. I understand tht x-sheet references cannot be the trigger for an automation to run on the destination sheet. I've added a helper column on the destination sheet that is a formula column that references the column that…
-
SUMIFS with wildcard (*)
Hello, I am trying to use the sumifs formula for summing values in one column based on the first two letters in another column. This formula is not working =SUMIFS([Total Invoiced]:[Total Invoiced], [Google Location ID]:[Google Location ID], "CA*") I have tried exchanging the criteria column at the beginning as well, and…
-
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…
-
Trouble with an IF formula
Hello! I'm having trouble with an IF formula (combined with two COUNTIFS formulas as results) where I'm trying to count specific rows in a sheet based on certain criteria. The IF statement is to count status if the quarter is current or before, otherwise exclude status if the quarter is in the future. Both COUNTIFS…
-
Add Quick Filters on Column Headers in Reports (like Excel)
It would be very helpful if Smartsheet allowed quick filters directly on column headers, similar to Excel. Right now, creating a filter requires multiple steps and saving it, which takes extra time for simple tasks. Having the ability to quickly filter a column by value, number, or condition (directly from the header…
-
Allow sending multiple rows from a Report (without redirecting to the source sheet)
Currently, when working with Reports in Smartsheet, it is not possible to send multiple selected rows if they come from different source sheets. Also, when sending rows, the recipient is redirected to the original sheet instead of seeing the content directly. It would be very useful to: Select and send multiple rows…
-
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?
-
New to SmartSheet - 2 questions on functionality
1: When using a SS form, is there a way to deny a duplicate entry based on an employee name or number? 2. Is there a way to somehow link from SS to Outlook to create calendar invites based on a date field in the SS? Thank you! Kat Gavigan
-
Welcome to the Education Community!
This is a space for Smartsheet users that work in the education industry to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform education. My name is Julie, I lead Education marketing at Smartsheet and am excited to get to know you all. I will be sharing helpful resources,…
-
Show Sheet Owners whether the people they are sharing to are licensed users
With the new changes to the licensing model for Smartsheet, there will be an impact from sheet admins/owners sharing their sheets to users who are not licensed. Unfortunately, the sheet owners have no way of knowing which of the collaborators are already licensed. I propose a feature where licensed users can see the…