-
Issue: @mentions in Dynamic View Link to Source Sheet Instead of the View
We’ve run into a limitation when using @mentions in Smartsheet Dynamic View comments . When a user is @mentioned from within a Dynamic View , the email notification they receive includes a link to the underlying source sheet, not the Dynamic View where the comment was made. This can be confusing—especially for users who…
-
I just shipped v1.0 of an open-source AI agent that lets you talk to your sheets — 73 tools, 80 formulas, BYOT, MIT licence
Hi everyone 👋 I've been a Smartsheet power user since 2013 and last month I finally caved on a side-project I'd been daydreaming about for years: stop clicking, start talking to my sheets. Today I'm releasing v1.0.0 of Talk to Your Smartsheet — a community-built, MIT-licensed AI agent that speaks the Smartsheet REST API…
-
Notifications in advance of dates
I would like to be able to program SmartSheets to send a notification of upcoming dates (i.e. 90 days before the date shown in SmartSheets) to specific people. I have played around with the notifications option and can't seem to get it fine tuned. It notifies of all future dates, not just those that fall within 90 days.
-
Delete Rows using an Automation
Please create automation to delete Rows. Using the move rows automation, we are able to move records to an archive sheet. The problem then becomes we have to manually delete records from the archive sheet.
-
Restaurar filas perdidas con datos adjuntos
Por error se ejecutó una automatización y se borraron todas las filas de una hoja con muchos archivos adjuntos, necesito recuperar todo y mantener el orden para poder continuar mi trabajo, ¿es esto posible?
-
How to maintain permanent inventory levels when source data is deleted weekly
Hi all, I am looking for advice on the best workflow to manage inventory deductions. I currently have two sheets where Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a…
-
How to maintain permanent inventory levels when source data is deleted weekly?
Hi all, I’m looking for advice on the best workflow to manage inventory deductions. I currently have two sheets: Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a SUMIF…
-
Sum if Multiple criteria matches across 2 sheets
Hi, I have two sheets containing a table of items. Sheet 1 is for entire item list and sheet 2 is for items used in a day. I want the sheet 1 to check the sheet 2 and reduce the numbers in the sheet 1 automatically. The problem I need to match two criterias. I tried following after making it work for one criteria. Any help…
-
Add multiple rows in a sheet when certain task type is added
We have some jobs that are repeated and require a standard set of tasks to be completed. I would like for when certain job types are added to a sheet that it creates a standard task list in another sheet. For exmple, when a kitchen renovation is added to the Sheet 1, I would like 10 specific tasks to be added to Sheet 2.…
-
Creating a folder in SharePoint from Smartsheet and naming it based on row data
I'm a Power Automate Novice and I'm not experienced in expressions. I am building a data flow in Power Automate to create a new Sharepoint folder when a new row is created in my smartsheet. I can get to the stage of creating a new folder however I would like to name it based on cell data in the row. I have tried to use the…