-
checkbox from reference sheet, multiple columns
Hi community i'm looking for a formula to automatically check boxes associate to dates from a reference sheet with multiple column of check boxs and dates. here are my tables: table 1 table 2 (if the box is checked, a date appears in the column at the right.) i want that the table 1 automatically check the boxes related to…
-
Override an Auto Number in One Cell
Is there a way to override an auto number in one cell, but leave the column as an auto number? Thanks,
-
Filter Feature Not Available in WorkApp
Hello! I am wondering why my team members do not have the option to "Filter" a sheet in our WorkApp. In the picture below you can see that the "Filter" option is grey. They have "Editor" roles for this sheet in the Roles/Pages settings of WorkApp. They are also "Editors" on the actual sheet (in Smartsheet Workspace outside…
-
Card view: can I make color changes persist?
Is there a way I can make manual color changes persist? I cannot find a conditional formatting rule that overrides manual color changes, so it's a mystery to me why my team's changes disappear. Thanks for any advice or guidance!
-
SmartSheet Attachments in Power BI
The out-of-the-box Power BI connector doesn't include attachments to sheets or rows. But we can use the SmartSheet API to pull all attachments. I have successfully tested in Power BI. However, there is a catch… SmartSheet uses AWS s3 as the file store The documents are stored as private The full URI returned by the api…
-
Help with Index Collect with Date Criteria
=INDEX(COLLECT({Snapshot Status2}, {Snapshot Row ID}, [Row ID]@row), {Snapshot Last Updated}, [Column5]1) I've got multiple data sheets set to copy rows to a Snapshot sheet every set date. I am now trying to get the status from the Snapshot Sheet to populate to another sheet so I can get a better visual display but I can't…
-
Ability to Customize Displayed Columns on Initial View of Selected Workspace(s)
Currently, after selecting a Workspace from the Browse panel the initial screen displayed has six columns displayed: Select (checkbox; ☑️) Favorite (star; ⭐️) Name Sharing Owner Last Update It would be great to be able to customize these columns with additional data points to aid with navigation and understandability (from…
-
Any recommendations for conversation export with a project to Excel
Hello, I am exporting a project that has a WBS column and would like to include the conversation. This currently exports to a separate tab in Excel but there is a disconnect between the reference conversation line item and the first tab where the row information exports. It typically shows one row off from the actual…
-
Registrar's Offices - How are you using Smartsheets?
Hello everyone! We're new to the Smartsheet Community and we're curious how other University Registrar's offices are utilizing Smartsheets. We're hoping to add our production calendar, academic calendars, and a project calendar. Our hope is that this will be a great way to track tasks completed throughout our office and…
-
Adapting an Existing Formula
Hi, I would like to adjust the formula that comes with the Project Management Office Templates. The Smartsheets template comes with this formula in the "Portfolio Metrics" sheets in the Total column and on the In Progress row. =COUNT(COLLECT({Project ID}, {Project Status}, $Label@row)). I would like to change Project ID to…
