-
Workflow schedule first weekday
When scheduling reports it is possible to pick first weekday etc, it should also be possible to do that for workflows. For example, run on the first weekday of a month
-
自己紹介をして、他のメンバーと知り合いましょう!
こんにちは。 コミュニティの他のメンバーたちについて知り、下のコメント欄で自己紹介してください。 話すことが思いつかず、インスピレーションが必要ですか?経歴、役職、Smartsheet をどのように使っているか、または使いたいか、自分についての面白いことや情報について教えてください。写真を添えると、ボーナス ポイントを獲得できます。 まずは私から!Smartsheet のコミュニティ マネージャーを務めているジュヌビエーブ (Genevieve) です。数式が Smartsheet のお気に入りの機能の一つですが、Bridge もそれに次いで同じくらい好きです。私はカナダ人ですが、英国に住んでおり、陶芸が好きです。…
-
Hyperlink to corresponding row in external document
I have a 600 row Smartsheet and need to provide hyperlinks for each row to an external Excel document. At the moment, a basic hyperlink will open Excel but place the cursor at the top of the sheet. Can I create a hyperlink formula to match the reference numbers on each row? Link for Reference 010 opens Excel document with…
-
The ability to use Placeholders in Update Requests
Please enable the use of placeholders in subjects and message fields on update requests. I recently found that when you use placeholders (the field names in braces, e.g. {{Project Name}}) in the subject line or the message field of an update request, it sends the default text. This is very problematic because it does not…
-
Help with formula: return value from cell in same row if criteria is met
Hi, I am trying to figure out how to write a formula to return a value from the SAME ROW, when criteria is met. I can't figure out what I am doing wrong with index/match/collect - I am hoping someone can help! Most of the tips/tricks/Community answers I have seen are using columns not rows, so I am not sure how to do it. I…
-
Option to Create New Sheet/Report/etc without using Solution Center
When I'm working within a sheet, often, I need to create a related sheet or report, and I know what I need and do not need assistance from the Solution Center. I don't understand why there isn't a choice to use it or not when you select "Create New" from the file dropdown. The Solution Center is a great thing, but I just…
-
Find the position of an element in a dropdown list
I have two columns: Column One: It's a multi-select dropdown list with the names of products (the quantity of selected products can be very long) Column Two: It has the quantities of each product in the same order as Column One, separated by commas. Example of one row: Column One (dropdown list with multiple choices):…
-
Side-by-side fields in Forms
Similar to other form products (like Form Assembly), I would like to place/format fields within the form with more flexibility. At the most basic level, I'd like to place 2 fields, side by side. My particular uses would be: Dependent Name: Dependent Age: And also: Income Type: Income Amount: I actually could use more than…
-
Summary Sheet Formula
How do I write this formula in on my summary sheet? I'm trying get total count of Reggie's "In Progress" tickets. Will this also count if the field has 2 names in that field? For example the field has both Reggie and Jon. =COUNTIF([Assigned To]:[Assigned To], "Reggie Andaya", [Status]:[Status], "In Progress")
-
Trying to Sync a Report with Google sheet
What is the best way to sync a report to Google sheet on a daily basis, Zapier cant sync report only Sheets which is disadvantage! Please let me know good services