-
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…
-
How to manage resource loading from a master sheet.
Hello, I trying to create a master sheet of a set of projects in order to help with resource loading questions. I can easily create a report that displays all the tasks for employee A vs employee B. I can create a report on all tasks across all selected projects with employees A-E. However, since we cannot use formulas in…
-
Project planning for an Agile development
Hi, I would like to understand how do you prepare a project plan for an Agile software development. I understand that first the product backlog needs to be created containing the list of features/bug/enhancements that are needed for the release and subsequently during the Spring planning, the tickets are discussed with the…
-
Move row - selected columns only?
Hi, We manage Intake to Archive in Smartsheet. Our Intake Sheet (source sheet), where we collect all project info, is rather lengthy. When an Intake Request has been approved, I want the row to be moved to an Implementation Sheet (destination sheet). The destination has different columns that the source sheet, only a few…
-
Dashboard Chart to Match Current User Report - Multiple Project Owners
Hello, I have a follow-up to a previous question answered here - https://community.smartsheet.com/discussion/comment/263483 Some of our projects have two owners (two contacts in the requestor cell) so I'd like the charts to reflect the project on each person's dashboard. Currently, I have 1 project in progress and the…
-
How can use the Countifs function with the Today function in the formula?
Hello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <=…
