-
If the checkbox is checked copy the row
I am having issues solving a problem. I have a sheet containing multiple columns (3 text/number, 1 date, 1 contact list, and 1 checkbox). Made out of around 150 rows. I want the rows copied to another sheet if the checkbox is checked. I tried: Using a copy row automation which works but rows are always copied at the end of…
-
Automation workflow not including attachments in notification emails correctly
Hi ! I am trying to figure out why some email notifications include attachments and others don't. I have a few teammates who add attachments to the rows when certain columns are triggered by a checkbox. I have my automations set below. And you can see once column was checked email includes attachment, but same email it…
-
Can we auto create the Row Link as a Hyperlink to autoconnect to that row yet?
Please tell me this is available. It would be nice to be able to create a column on a sheet that will automatically create a hyperlink to that particular row!!!
-
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.
-
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.…