-
Plotting cost over time
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months. I am pretty sure each cost would need to be broken down into…
-
Workspace & Sights
Hi all. I was wondering if there is a way I can copy a dashboard (Sights) to more than one workspace or folder? For instance, I have multiple workspaces that hold reports, sheets, and dashboards based on category (audits, projects, document updates, etc) and I would like to store the dashboards in their respective…
-
Card View Functionality on Sights View
When working within a Dashboard, if I drag a card from one lane to another (Uncategorized to In Progress for example) does that information populate and work on the underlying sheet? Right now on the dashboard when I drag the card from one lane to another it updates the status (by adding "In Progress" text etc) and when I…
-
Update Dashboard Through API
Is there any talk for the potential to update sights using the API (other than renaming the dashboard)? We are using the API to copy everything in a folder to a new folder, but want to be able to update the embedded map we have on the dashboard using an address in the body of a POST.
-
#Unparseable error
I'm using the system to monitor and report progress to our client. We do surveys on their sites and perform installations. On top of the sheet, I have locked 6 lines that I use for summaries of the totals with simple countif statements. Any ideas on why?
-
Dashboards & Formulas
Hello, I have (2) fields on a sheet that are driven by dates. here is an example: =if(and(today()>=date(2019,9,1),today()<date(2019,10,1)),"Period 1") So on the first of each month, this field on my dashboard should update to the current month. For some reason, the dashboard will only update if the sheet is opened. is…
-
SIGHTS - Error: "Source report missing" in Report widget?
In a Sight there is a section where a project plan is shown via report widget. Source is a report based on a project plan. It worked well until today... All of a sudden the plan in the Sight is gone, although the source report is still available and showing content correctly. Since I had no idea for the cause, I tried to…
-
Image in Dashboard
I am working on a template for my dashboard that would show an image of the project in the top right corner. Now this image will change for each project. The goals is to have some of the data for the dashboard pulled from a Metric Sheet, I have added the image to a cell there and figured I could use the Metric widget to…
-
Sights Dashboards - gantt chart reports are formatting weirdly
Ok I don't know what other term to use...but on every dashboard the gantt chart reports have all reformatted themselves to make whatever column in the middle of the report HUGE...and shrinking the gantt chart part to a very small and kind of dumb looking last column. I love you Smartsheets --but you are making it almost…
-
Can we show Sheet Summary data on sheet itself to avoid inputting data twice?
Project Sheet 1 and Project Sheet 2 have detailed data. Sheet_report_summary pulls the "Sheet Summary" data (icon in the right pane) for executive summary. In our engineering meetings, we drill down into the details of each sheet. Can I show the "sheet summary" data on the sheet itself? For example, a project is RED-…