-
Trying to create a Projections sheet and need some suggestions please!
Hello everyone. I am hoping someone may be able to give me an idea on how to create a projections sheet for our engineering projects. I would like to build it out so I can spread the total hours per staff type over the duration of the project. I have tried a few different ways and cannot seem to figure out how to create it…
-
Lookup & Display First Non Empty Cell In A Range of cells within a column
I am attempting to write a formula in a header cell that returns the first Non-Blank row in a series within the related column. Excel permits this by using the Index and Match formulas but requires that "CONTROL, SHIFT & ENTER" be pressed for the formula to work. When attempting this in SmartSheet, I receive an "#INCORRECT…
-
RAG indicator options
Hi there community I have a portfolio of several hundred projects being monitored and reported via dashboards and reports in Smartsheet. We are currently using RAG indicators against schedule as follows: Red - Incomplete at reporting date or due date passed Amber - at risk Green - schedule within tolerances (+/- 10%…
-
Reporting like pivot or sumif. How to roll up values by name or category?
Is there a way to combine cell entries and give the total assigned to that category? Ex. Project Lead Cost savings John $100 Mary $500 Bob $400 John $200 Mary $75 Bob $60 REPORT = John Total = $300 Mary Total = $575 Bob Total = $460
-
Limiting Characters in a Cell/Date Validation
I want to limit the number of characters that a requester can enter into a cell via a form. The use case is that the user is entering a new request for consideration into an Intake Form. In assigning a name to their project request, we want to limit them to no more than 25 characters, based on limitations from another…
-
Is it possible to add weightage in Smartsheet?
Team, As part of my requirement, under my Survey, i have questions with list of choices. So i would like to pre-configure the weightage to these choices so that, once the end user selects a value, it should automatically populate the weightage in another table. Which should be later used for reporting purpose (if possible…
-
Gantt to Grid Report view
I have many projects (let's say 20) all with the same many tasks (Let's say 20 again). The Gantt view is great to handle predecessors and additional information associated with each task. However for a project status meeting I would like to view a report horizontally, see image attached. Is it possible to make a report…
-
If Cells not blank equal max date
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Basically I am tracking when people submit multiple documents, once all are submitted (i.e all dates entered) I issue them a…
-
Formula that will add 1 to a Qty row
Newbie to Smartsheet...I am wanting to write a formula that would at a quantity of 1 if the prior column has a date in the cell. I am trying to calculate the # of installations. basically if a date is entered into an install date column, I need the formula to add a quantity to a install quantity column. thanks, sGF
-
Returning last entry in a database column
I have created a database that adds a new line against a date each day. From this I am building some metrics and then a dashboard which will show Daily Performance but also week to date, annual etc. I am struggling to reference the database and return the last entry in a column. It seems that Lookup, Vlookup or Index…