Comments
-
Hi @Ayperi Uzun If the LINKs used in the Dashboard are to Smartsheet items like Sheets and Reports, it is a good idea to "save as new" Workspace or folder containing the Dashboard, Sheet, or Report. In this case, the link in the newly created Dashboard will be to the newly created Sheet or Report, not the original Sheet or…
-
Hello @DKL Using the Dashboard and two reports, I have come up with a way to display a calendar in Weekly units for this month and a calendar in Months for the next month and beyond. First, add the columns This Month, Past Month to the source sheet. (Check Box in the example) Set up the following conditional filters for…
-
@mahmadi我使用以下方法achieve this in the Core App only. Sheet for display Auto number Row ID column. Read-only columns and editable columns for 20, say 40 people. (in my demo). 20 columns for 20 people to display the URL of the form created in step 2. Add formulas that retrieve the latest data from the…
-
It is very disappointing that there is no API for updating dashboard widgets, workflow and forms. When you create a Dashboard with form link by the control center, the link points to the blueprint sheet, not the newly created sheet. The copy & move rows workflow created by the control center points to the blueprint sheet.…
-
@BKing
-
@Sherry Fox https://smartu.smartsheet.com/2023-core-product-certification-exam-guide/1505655 65 questions (60 scored and 5 unscored) 90 minutes.
-
@Enoch Mak Method 1 responds to your "added over 100 columns will slow down." Method 2 answers your "a more simplified formula or solution." (I have written this comment in a more general form to help other users in the community as well.) Method 1: Compare duplicate tasks of the same period by cutting out the Contacts of…
-
@Angie Little Feel free to reach out with questions or issues as you test these. Good luck!
-
Hi @Angie Little This is an interesting topic, so I have created a solution to demonstrate. The easy way is to use a report. In the project sheet, create a column called Type / Priority that combines Task Type and Priority, enter the values in a formula, and group them using this as the key. In the report, you can group by…
-
Hi @April W. We have been unable to reproduce the inability to see the report on a published dashboard. Did you not publish the report? If so, the report will only be visible if the original sheet was shared. As an example, look at the following demo dashboard.…