-
Sum of a column by cell color?
Not sure if this is possible or not. I was looking into conditional formatting, but didn't seem to find anything that would work. I simply want to get the sum of a column based on the color of the cell in the column. In other words, I only want to see the sum of red cells and exclude green cells. If this is not possible,…
-
Changed Duration Time for Report
Hi, I just updated a couple of my sheets and changed the duration time to "0" to reflect a milestone. When I run my milestone report these changes are not updated. Is there a delay for some reason. I thought that updates once saved would be immediately reflected. -Laura
-
Cell Linking Blank Templates
I'm looking to create a "Packet" of 3 sheets that cell link together to be used for multiple projects. Is it possible to create 2-3 Blank Templates set up to cell link with one another, without it getting altered when the blank template is used again for a different project? Hopefully this explaination makes sense. Thanks…
-
Beta of New UI?
Is there any way to get a beta view of the new UI? Just encountering UI issues while working in currnet view. Small things like makin the tabs smaller or multi row. Using more of the screen etc. I saw the new release will have many of my concerns addressed. But really wondering how to get on the inside track of beta views…
-
Date fields not working on Live Data Link API
This is day two of the date fields coming into our excel sheet as 01/01/1900 and it causing problems with our scheduling needs. What is the ETA of this getting resolved?
-
Smartsheet Workspace to excel using the connector
Before upgrading to the next tier (where the connector exists), I want to make sure what I want to do is possible. Can the connector pass an entire workspace to Excel, rather than individual files. There is a workspace that contains many gantt chart files and an easy to view row summary of each chart is wanted such that it…
-
Calculate Difference Between Latest Entry and Previous Entry (Dates)
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name:…
-
Resource profiling
I have a requirement where each task requires a % allocation profile instead of the standard flat % allocation throughout the duration of the task - is it possible to set this up? For example, a task is 9 months long: Month 1 requires 50% Month 2 - 6 requires 100% Month 7-8 requires 50% Month 9 requires 25%.
-
Charts From Drop down Data
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…