-
Automatic Capabilities
Hello, I am looking for a little direction. I am new to smart sheet and went through basic capability trainings etc. However, I am looking for assistance in having a smartsheet automatically move information down and date it. Quick reference to help better understand my question. I work for a commercial real estate…
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Combine IF formulas in one cell
Hello, I'm trying to create a %Complete column based on a drop down list column called "Status". For example, I'm looking to combine these formulas into one cell, then copy and paste to all other cells in the same column. I'm very new at this and cannot figure it out. If there is a better way top accomplish what I'm after,…
-
Best "infrastructure" columns for portfolio reporting
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date). What other hidden columns do people include in…
-
VLOOKUP Function
It seems like others have inquired about VLOOKUP. I'm sure this is in the works as part of "enhancement request". Is there a timeline when this will be released?
-
Forms
Looking for some help in a Form that I'm creating. I am the Safety Director for a painting contractor and I'm trying to create a form that my crew forman will be filling out every morning. Why can't I have more than 1 field named the same? I'd like a check-box or drop-down field, for every employee, that specifies if they…
-
Organizing/Sorting Workspaces
Hello Fellow Smartsheet Community Members, I am wondering if anyone knows if it possible to sort items in a workspace by the item type. I have a workspace that has a mixture of sheets and reports. Ideally, I would like a way to group all the reports together and all of the sheets together. An anaology is clicking the…
-
Rows missing
I was working in one sheet (with autosave on), switched to another sheet and when I returned the rows were missing - there is no hierarchy/drop downs and it looks like the rows are ´hidden´. Any ideas how I can retrieve the missing rows?
-
Count & AVG only if another column contains "text"
Hi Again, After scouring discussion boards I have managed to Average the total of the rows, see below =IF((COUNT([Days to respond]194:[Days to respond]214)) = (COUNTIF([Days to respond]194:[Days to respond]214, 0)), 0, SUM([Days to respond]194:[Days to respond]214) / ((COUNT([Days to respond]194:[Days to respond]214))))…
-
Update Requests 'Today'
Hi, I have a planned date column, and I would like to send out an update request to the contact column when the planned date is = to today. Is this possible? Thanks, Aaron