-
Selecting the best Smartsheet for your project
I need to make sure I am selecting the correct smartsheet workspace for my project. I am trying to create a workspace to track and share client implementation. How do I add a Start date and then the sheet automatically adds task dates, as well as deadline, completion percent dates without having to add all manually. I seem…
-
Formula to determine number of plants still in inventory which were acquired more than 6 months ago
Good day, I have a native plant nursery, and I am looking to determine the number of plants that are still in the inventory and which were acquired 6 months ago or more. So, a rolling SUMIFS maybe? Wanting to do this in the sheet summary, but open to other solutions that I can display in the project's dashboard.
-
自動化設定でシートサマリの情報を使いたい
自動化で通知ルールを設定しようとしてます。そこで通知の宛先を、シートの列情報として保持している連絡先情報でなく、シートサマリの方で表している連絡先情報に対して設定できないでしょうか。。？
-
I don't understand my Sheet Summary formula
I've been using sheet summary formulas for a week but have been struggling with something I don't understand all afternoon. I have a summary field called % Planned Complete. For simplification, I'm testing this formula: =INDEX([% Planned Complete]:[% Planned Complete], 21) * 100 But it won't return the value for row 21 in…
-
Can I copy/paste summary fields between sheets?
I've just added six sheet summary fields to a sheet. But I have to add the same six fields to another eight sheets. I've been looking in the posts here, and I don't see anyone addressing whether there's any way to copy/paste the
-
Child row and Multi- contact cell selections
I am currently developing a portfolio management system in Smartsheet to centralize our work. To accommodate multiple project owners, we are utilizing a multi-select contact cell. When a user is assigned as an "owner," the initiative appears on their individual summary sheet. However, we have encountered a challenge: in…
-
Quickly delete Sheet Summary
HI there! I think that I already know the answer to my question but I am hoping that the Community will tell me that I am wrong 😊 Is there a way to quickly delete ALL of the fields in a Sheet Summary without having to select the kebab and the scroll down to "Delete Field" for each individual entry? Here's where I am at: I…
-
Dashboard Last Updated Date
I would like to display the last time the dashboard was updated. My approach was adding a date field in the summary data that automatically pulls the last saved date of the sheet. I don't think I can do a formula in the date field type. Any other suggestions?
-
Is it possible to reference a cell or summary field in a column formula?
At the top of our templates we have a Summary section where project (deliverable) details and key people are specified. I am wanting to reference the 'Deliverable Sponsor' cell within a hidden column on the sheet so we can create reports pulling through all row data across all deliverables that belong to that Sponsor. From…
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.