-
Workflow or Alarm
Hello all, I work in company established in Germany. So my english writing can confuse you. I am new here and want to ask a question regarding the workflow / alarm tool. The automated mails are linked to a formular or the receiver gets a link to the complete Project. Is it possible to link the alarm to a DashBoard? This is…
-
Conditional Formatting doesn`t apply to Report
Hi there, I was playing arround with the conditional formatting and stumbled across a problem. I have some rules, based off the "Modified" column. When those rules are used on a custom column, it works just fine. If the rule is used on a system column (Modified in my case) it doesnt seem to apply the colours in the report.…
-
Getting sheetnames to appear in certain order in a report
Hi there, Can anyone help with how to configure sheet name so it appears in a particular order when shown in a report? I have used numbers (1. Red, 2. Yellow....) and letters (A. Red, B. Yellow....) but both approaches do not work consistently. A-G seems to work but the following letters dont (see image) . The numbers seem…
-
Report and Calendar View
I created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main sheet. In calendar view, if you click on a scheduled item, all the details from the main…
-
Web form links from report not working
I have a report that is displayed on several dashboards with links to a form. Up until recently, maybe a week ago, these links worked. Now, I get a page not found error, even though the address is correct. Has anyone else ran into this before?
-
Status Report based on certain conditions, i.e. dates, status etc
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
-
Multi Select Column in Reports
I am using the new Multi Select Drop Down Column type, I have 2 options for check off in it. When I want to filter it in a report the check off items don't show up. I can find the column in the "What?" Section, I add it, but it will only let me filter it by "blank" not by the 2 options I have put it as check off fields in…
-
Dynamic reporting across multiple sheets
My organization recently moved from Google sheets to Smartsheet. We were tracking the number of jobs completed by each team member in the last week. We had multiple groups of jobs that would be uploaded as a new tab on the sheet. The reporting we had set up was able to search the new tabs for data to include in the report.…