Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Smartsheet - Spotfire LInk
Are we able to link Smartsheet directly into Spotfire. Currently, I'm exporting the data in my Smartsheet into excel and then manually updating Spotfire for my daily metrics. It would be great I could link the two so this could happen automatically.
Gantt chart top level visual summary of dependicies?
Hi, Is there a way when you collapse a top level item in a gantt chart to see colored shadings of the dependencies within IN that top level overall grey bar? Let them take the color from the assigned color of the dependency? For instance, I have 4-6 items within an entry but I don't want to expand the entry just to see…
Year to Date calculation, This Year vs. Last Year
I am trying to do a year to date calculation on some sales data but would like to bais it on this years sales vs last years sales to keep track of how we are doing month by month. Do I need to do a horizonal lookup? A sumif? Is there a way to add a current date to the sheet, then simply do if sum if >= to this date? Please…
Can an email from another system automatically be loaded?
Hi have a survey system that sends an email to a user with an attachment. I would like to know if SmartSheet can automatically load that email into a sheet for future reference? The idea is to have the system automatically email SmartSheet and then it can be loaded - hope that makes sense
I'm interested in seeing out-of-the box, unique examples of webforms others have used in the past?
I'm specifically interested in seeing webforms that allow the end-user to update their timelines on existing tasks. Maybe webforms are not the way to go; maybe row requests? I'm open to any and all ideas and would be greatly interested in seeing real-life examples. Thank you, Crystal Lehto
SUMIF YEAR
Hi, I would like to do: SUMIF(YEAR(A1:A50), 2016, B1:B50) The above doesn't work. How else can I construct this formula? thanks, Column A is a date column Column B is a currency/number column
Search Operators
Are there any search operators built into Smartsheet? For instance, I'm looking for a name in a specific sheet and want to search for Bobby in:"Info Master". I know I can search and then filter deeper, but figured it makes sense to rely on operators to speed up the proeces..
Tracking of RYG Status changes
We have a fairly complex sheet that we use to track survey requests between us and one of our clients. One of the columns is a Status indicator using RYG balls. Both us and the client collaborate on the same sheet. We use it as follows: Green - Survey on track and continuing Yellow - Issues on the survey that must be…
Clone Columns including Conditional Formatting
I have a Smartsheet that shows the status of an item by date and I'd like to be able to copy or clone the column with all the conditional formatting. Is there any way to do this?
Not sure why my dates aren't rolling up to the Parent Row or Top level summary
I could have sworn this was working before. My dates are not rolling up to the top level summary row. See image below. Also predecessors are not calculating so my dates are not moving based on its predecessor.
