-
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…
-
Board View Report Without Giving Users Access to Sheet
We have a Smartsheet form where users can request a certificate of insurance. Their email address is recorded in a contact field. I've created a report that filters the contact field to the current user. We'd like for them to be able to see the report in board view, but only for their requests, and do not want to give them…
-
Parent/child rows in a report even if not assigned to parent row
I need to build out a report that pulls the below information: Report needs to show the parent and child rows -Parent is not assigned but child is assigned -Parent is assigned and child is assigned I am open to helper columns but everything I have tired is not working. Formulas: -Parent Helper: =COUNT(ANCESTORS())…
-
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!!!
-
Sharing with default Filter applied
I am wanting to share content that has a default filter applied where it only pulls specific rows (leveraging "Current User") filter. Originally, I had tried leveraging a report, however, that does not allow the user to be able to add rows and self assign (unless experiencing user-error). Having a report is my preferred…
-
renewed subscription and all files are read only: how to fix this?
renewed subscription and all files are read only: how to fix this?
-
How can I make a timeline widget respect the structure and order of my plan instead of sorting items alphabetically?
Hello, How can I make a timeline widget respect the structure and order of my plan instead of sorting items alphabetically? I’ve already tried using filters, but when I apply them, the items are still automatically sorted alphabetically or by date. Thank you in advance.
-
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…
-
What's breaking my task dependencies when using elapsed day duration
Hi I ran into an issue today where my smartsheet timeline was updated without any user's input and several dates were changed cascading to the entire timeline. I tracked it down to several tasks and started correcting them, realising that there is some issue when dependencies are using regular "day" duration and some are…