-
Copying column to another sheet
Hi, I have a sheet that includes a calculation to update the value in a specific column in real time. We'd like to track the values over time (monthly) and are looking to automate the process of copying the column and pasting it to another sheet, so we'd be able to create a line graph that shows changes over time. I am…
-
New Automations and Smoother Days Ahead!
I am looking forward to my workflow being easier here for myself and my whole department! I have learned so much from ENGAGE and can’t wait to apply it!
-
Return blank when count total is zero
Can you give me a variation of this formula that delivers a blank if total counted is 0? I want to use it in forward months so I don't have to update the metrics sheet monthly, if possible. Thanks, Lisa I tried the IFERROR and IF(COUNTIFS( I could find but most deliver Incorrect Argument. =COUNTIFS({4Q2025 FPG thru Oct…
-
Can form submitters update their form information w/o being shared to the sheet?
We have external sponsors submit information via a form. At the time of submission, they do not always have all the information needed. We need a way to send them reminders with their partially completed form and have them complete missing information without sharing the entire sheet with them. Is this even possible?
-
Automation Help Please - Change Cell
Hello smartsheet community! I am basic familiarity with automations. I've created dozens, but they have all been fairly simple. Right now I am working on some automations for our project management templates, specifically our project plans to automatically when a task is delayed. I have created 3 separate automations…
-
Data Shuttle to Power BI
I am working on a project for a client, where they want to have dashboards built out for data analytic purposes that update automatically. The client already invested money into data shuttle, so data is automatically going to pull from the different data sources. Given that Smartsheet dashboards have limited analytics…
-
Use AI to create WBS numbering
So much time, effort and $ has no doubt been invested in installing AI into Smartsheet yet the most fundamental issue of WBS numbering still has not been addressed. How about using your own (or someone else's) AI module to generate the process to automatically insert and update the WBS numbering for all Smartsheets? Then…
-
work order billing and Inventory Module intergration
Hi, My name is Jeffrey Beal, and I am the Procurement and Warehouse Manager, overseeing direct reports including transactors, a Procurement Analyst, a Storekeeper, and a warehouse worker. My team and I currently track and manage our purchase requests in Smartsheet, alongside two other different systems, to support our…
-
E-mail address format - update to allow e-mail addresses to start with a +
We have an update request embedded in a workflow but cannot send these to all our external partners due to the format of their e-mail address. Emails that start with a "+" such as +ABC-123-Country@domain.com are not supported due to the leading + Please extend the functionality to support this e-mail address format - will…
-
autopopulate the percentage complete based purely on the time passed
My goal is to have the percentage update automatically each day. If the task has a duration of 45 days and we are 3 days in, I need it to show the percentage complete. It would cap at 100% once it has reached the end date