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 Ma…
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 …
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 …
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 …
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. Ba…
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…
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…
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…
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/…
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 mov…