-
Contingency based on BRAG status
I've been using smartsheets for projects plans for some weeks now and can manage all of the usual functions that I'm used to but I've got a new challenge. How do i add variable contigency to the duration of a task based on a BRAG status? Example: In an Agile development environment the first pass estimate is RED and should…
-
DATEONLY Formula Error Message
I cannot get my DATEONLY formula to work. It keeps giving me "missing or invalid parameters" as the result. I am trying to create a formula that gives me a date variance between Planned Start and Actual Start. My two column names are Planned Start and Start and I am trying to start in row 5. This is the formula I have and…
-
use conditionals or formulas to show or hide child rows?
is this possible? Example: Child rows start hidden. If a column in a parent row is checked, the the child row is made visible. More info: I am trying to create a type of set up where I can use a sheet as a form where if the person enters "yes" in a cell, I an guide them to answer the next in a series of questions. This is…
-
Booleans
I need the formula for counting the checkboxes in a column.
-
Can I use Find in a count formula?
I have a spreadsheet that is a calendar for consultants. I have the primary column using the consultants name as the Grandparent, the Month as the Parent and the weeks of the month as the children. * Consultant * Month * Week * I have another column that shows availability using RYGG for different status'. * What I want to…
-
Conditional Format by cell unique based on row or column
We are undertaking major project across teams and areas and looking for a way to create a dashboard type display with ability to add spcific details. Basic requirements include. 1. We have 16 different workstreams grouped by column (overall status, staffing, planning, security, rerporting etc.). There are about 30 modules…
-
Question about creating a pricing sheet with multiple linked sheets
Hello, New to SmartSheet and have only been through the basic training video. I understand this product is super powerful and can do just about anything related to spreadsheets. I just wanted to reach out to the community to see if what I was looking to accomplish is something the group feels is obtainable before I keep…
-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
-
Helpful Formulas for Larger Schedules
Here are a few formulas which are perhaps a bit more advanced, but have really helped our organization. I have also placed them into a published sheet found here, where you can see the formuals working. Weeks to Start Calculates the number of weeks away a task's start date is. This works for any date, such as a task's…
-
Using SUMIF when column is not blank
Hello, I am trying to sum only the values of the children in one column for which the corresponding cell from another column is not blank. I tried this formula: =SUMIFS(CHILDREN(Amount25)), (CHILDREN([Date Paid]25), NOT BLANK), but it did not work. Is it even possible? Thanks!
