-
Is there a way to convert a large number of contact cells at once?
I have over 5000 rows in a sheet that has been exported from ServiceNow. Every row has a contact cell that is filled out with a raw name, no company email. Is there a way of converting every cell into the respective company email for that person at once? The manual method, typing their name and selecting the pop up, will…
-
自動化（Automation）での更新依頼メールから”シートに移動”が表示されないようにしたい
こんにちは。いつもお世話になっております。 自動化の機能を使って、シートの共有者（＝担当者）に内容の更新依頼を定期的に出しています。 担当者へはSmartsheetから自動でメールが届き、「リクエストを開く」のリンク先の更新フォームから情報の更新をお願いしています。 このメールには「シートに移動」というリンクがあるのですが、このリンクを表示されないようにする方法はありますか？ シートには担当者には共有したくない情報も含まれているので、担当者へはそれら情報を除いたレポートを作成して共有しております。 一方で、シートから担当者とコメントのやり取りやレポートからの情報入力をしてもらいため、シート自体も担当者と共有をしています。…
-
Question: Hide/Unhide columns
Hello Smartsheet Gov community! I have been a Smartsheet user for many years and exclusively in Smartsheet Gov for 2.5 years now. Today one of our users shared that a free collaborator had unhid columns in a sheet. I shared with her this wouldn't be possible since only licensed users can hide/unhide columns (even with…
-
Formula for days of week a ticket was submitted
Hello, I am looking for a formula to put the days of the week a form was submitted. i.e. monday, Tuesday, Wednesday, etc. I already have a created date column which i need to stay as it is but want another column for the specific day that it was.
-
Is anyone else losing their mind over the changes Smartsheet is making without announcing it?
I don't understand why Smartsheet changed these icons? They no longer match what is used in a Workspace or Folder. When I teach Smartsheet, I use the icons (sheet/grid, report, dashboard, template, folder, workspace) to help people understand at a basic level what Smartsheet is made up of. THESE make absolutely NO sense…
-
Ready Status Formula or Column
Hello, Could you please create a formula or column which lets us that a row is ready to be executed, as the predecessors have all been completed. Best Regards, Kartik Shah
-
How can i calculate the % Complete at a sub-parent level based on multiple criteria?
Hello and thanks in advance for any assistance. I have spent a ton of time attempting to solve and am tossing up the flag. I have a sheet that needs minimal column formulas due to the line/cell count potentially hitting the base reference limits. I have an overall % complete being calculated on the sheet itself already.…
-
Smartsheet not recognizing a number value
I have a sheet with item numbers and Dates when a purchase order is due. Some items have multiple purchase orders outstanding, so I have a MIN(COLLECT statement to find the earliest of the open PO dates for that item. What has me baffled is that for "Item" that has a six digit number, it doesn't return any value. If it has…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
How to Get Pie Chart to Show Total Complete VS. Incomplete
I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking… Here is how I have it displayed now… and also a…
