-
Multiselect column for each row return all associated matches from another sheet.
I have a convoluted problem, index match only works for single input, and I have a multiple select column for business unit with up to 6 options resulting in up to 6 individuals needing to populate the contact column from sheet 2 in the project tracker and unlike excel I cannot use wild cards. Sheet 1 Project Tracker sheet…
-
Pulling Parent Data without Grandparent in a column with a column formula
I would like to pull data from a parent row into the children but with a column formula it goes back to the grandparent, how do I exclude the grandparent data?
-
How to return multiple values from a sheet and paste them on multiple cells, based on criteria?
Hi, I have one sheet where there is a column with order numbers. There is also a shipping date column, which has a shipping date for each order number. The sheet itself is called Shipping. On another sheet, I want to return all order numbers of the next 3 weeks. I tried using the Index(Collect()) formula at first, but…
-
Outbound Cell Limit - Who's Calling Me? (Outbound Cell References)
@Andrée Starå @Paul Newcome @Genevieve P. I understand from a different post that there is a 25 million limit on outbound cell references. Is there any method to find out who's calling the master lookup (source) sheet? A list of all sheets that reference the Lookup sheet? What about pivots and DataMesh - any ability to…
-
Can I link 2 sheets with a formula that feeds many date columns?
Dear All, would you please advise if this is possible? if yes, would that be a combination of JOIN/ COLLECT/ IF / AND? If no, is there a way around it? I need the dates in these 10 columns: to feed into these 2 date columns: The condition is that Discovery Start Date has to feed into Phase Start Date when the activity is…
-
Introduce yourself & get to know your peers!
Hi there, Get to know other members in the Community and take a minute to introduce yourself in the comments below. Feeling at a loss for words and need a little inspiration? Tell us where you’re from, your role, how you use or hope to use Smartsheet and a fun fact or two about yourself. (We love to learn about your…
-
グローバル コミュニティにご参加ください。日本語でつながりましょう!
この度、Smartsheet コミュニティにグローバル ディスカッション を公式に導入したことをお知らせいたします。 Smartsheet では、効果的なコミュニケーションの力を理解しており、言語は共同作業と理解を促進する上で重要な役割を果たしています。この点を考慮した上で、スペイン語、ドイツ語 、日本語 を話すコミュニティ メンバー向けの新しいトピックを作成しましたので、ぜひご確認ください。 注意事項: 現時点ではこれら 3 つの言語のみに対応していますが、今後さらに言語数を増やしていく予定です。ぜひ、ご期待ください。 製品に関するアイデアの投稿は英語でのみ対応していますが、アイデアへの投票はグローバルで行えます。…
-
Move Row resulted in duplicates
We have set up our company timesheets in Smartsheet. At the end of each billing month, we move the relevant timesheet rows into history for billing purposes. We normally use automation for this. However, the automation is giving us problems because we have too many cell references in the sheet (we still need to fix this…
-
Automation massage body of 2000 characters
Hi everyone Can it be possible for the automation massage to give more than 2000 characters per massage?
-
Import data into a datatable from power automate
I am using power automate to get data from my SQL server database. I want to then push that data to a smartsheet datatable. I currently am able to push the data to a smartsheet using insert row in power automate. another option would be to push the data directly from SQL database to a datatable. I am new to smartsheets so…