Discussion List
特定の列のみを別のシートにコピーしたい
こんにちは。 元のシート(シート①)のチェックボックスをONにしたら、その行を別シート(シート②)にコピーするAutomationを使用しています。 今はシート①のすべての列がシート②へコピーされてしまっているのですが、シート②へは「シート①に含まれている特定の列だけ」をコピーされるようにできないでしょうか。 シート①で列を増やすと、シート②へコピーするたびに、勝手にシート②の列が増えていってしまうのを制御できないかと考えています。
Why can I edit on my phone but not on laptop is read only
レポートで列をmergeして表示できますか?
2つのシートに記載されている内容をまとめたレポートを作成したいと考えています。 シート①:IDが付番された案件についてA1, A2, A3,・・・A10と10列の項目について記載あり シート②:IDが付番された案件についてB1, B2, B3,・・・B5と5列の、シート①とは違う項目について記載あり このシート①とシート②の項目の中から希望の列(例えばA1, A2とB1, B5)を表示させるレポートをシート①とシート②を使って作ることはできますか? INDEX,…
Prevent Duplicates
Hello, I have a column name PO Number for example. This is a text/number column. The value I will enter in this column is unique and should not be repeated. Is there any way to accomplish this? Say I am entering Serial Numbers, and if I enter a repeated serial, or value, can smartsheet block it, or tell me I am entering a…
RYGG ball and task status formula based on % complete and due date
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
=Index(Collect(... Contains
Hello. I'm trying to return the "Flag" onto 'PS Bids Worksheet' from the 'Vendor File Nomenclature' (See 2nd snip below with blue highlight) page IF the Primary Column on 'PS Bids Worksheet' CONTAINS the description located on 'Vendor File Nomenclature', and it works great if there's not any additional words and/or…
Form entry data aligning with pre-entered data on grid
I track a lot incentive cards for my work. As I have began to use smartsheets, I think it will be better to track here. I purchase incentives in bulk quantities and distribute to staff to give to research participants. If I enter all card numbers into the first two columns as below, I am wondering if I could utilize a form…
WorkApp folders
please add folders to organize workapp items
Smartsheet burndown chart not appearing
I came across this link for a burn down chart template on Smartsheet's website (https://docs.google.com/spreadsheets/d/1ekfR_xE9YnDzrJxHCAjYDAFiGDqMEdBfSXGbIuN89rw/edit#gid=552825796) but then when I go to select "create in Smartsheet" it keeps telling me I need to login (which I have) and it won't show me where it's…
Auto populating Rows based on the number in the Qty box
Hi. Is it possible to auto populate rows based on the number I have in my QTY cell? I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or…