-
Work Flow - Clone to another worksheet
I LOVE the work flows!!! But I have 15 facilities and 15 of the same worksheets. Is it possible to: 1. Clone the work flow from one worksheet to another or 2. print the work flow so i can enter the same verbiage & flow in all the sheets. While I am here - is it possible to send an Update Request WITH an attachment? thanks!
-
Is it possible to share a Smartsheet that has a locked default filter with someone else?
We want to share a Smartsheet with others, but we only want them to see certain parts. To do this, we created a filter and set it to be the default view for people with viewer access. However, when we tested this with a team member who had viewer access, they were able to exit the filter. We want to prevent the person who…
-
Notification: Changes in Sheet
Hi, I created an automation to move all rows from one sheet to a new, archived sheet once the task is marked complete. During videos I watched and in my test runs, I was under the impression that old tasks marked complete wouldn't move and I would have to do that manually. I was wrong, and instead of moving over 1,400…
-
Sheet Summary/Sheet Summary Reports Questions
Hi, Is it possible that if you have several dates listed in the sheet summary on a project, that those can be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of dates…
-
Project Status Report > Horizontal View
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in…
-
Moving Rows between sheets
Hi! I have a Original sheet with data being inputted by different users and locations. I was trying to build out reporting so I moved one locations data to another sheet. Is there any way to move it back to the original so I can change it to copy rows to the secondary sheet instead? I don't want to risk losing all the…
-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
特定の列のみを別のシートにコピーしたい
こんにちは。 元のシート（シート①）のチェックボックスをONにしたら、その行を別シート（シート②）にコピーするAutomationを使用しています。 今はシート①のすべての列がシート②へコピーされてしまっているのですが、シート②へは「シート①に含まれている特定の列だけ」をコピーされるようにできないでしょうか。 シート①で列を増やすと、シート②へコピーするたびに、勝手にシート②の列が増えていってしまうのを制御できないかと考えています。
-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
Get Sheet (ID) by Name using Smartsheet API
I was wondering if there is a way to get the sheet Id of a specific sheet using the name of the sheet. Get sheet accepts the sheet id to get the sheet info, but I would like to get the sheet using the name. In Bridge, you have the option to get sheet by id or name, so I was wondering if there is a way to get it apart from…