-
Resource Planning: Calculating Weekly Hours Remaining for a Project
Hello, Goal: To view estimated hours per resource per week. I am looking for a way to calculate the weekly hours remaining on a project, per person. I am referencing my project plan as the source sheet which has: Resource Name, Estimated Hours, Start Date, Due Date, Week Start, Task Name, etc. In a summary sheet, I would…
-
Automation for notifications only partially working
Hello all, I have an automation on a sheet that runs when a value is placed in a field to notify individuals on the team of said information in the field. For some reason however, the automation runs and only sends the email to one of the recipients not all listed in the automation. For example, the email recipients…
-
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…