-
how to get a weighted average for a parent row, when children rows have "<" signs added to it
Hi there, I am currently working on a formula where the parent row will display the weighted average of children cells, based on the input weights. However, the problem I have at the moment is that there are numbers of cells with "<" sign added in front of the number and because of that, those data get ignored in the…
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
Can you average red green yellow symbols
I have rows that each have a RYG symbol and a collection of rows roll-up to a section summary. Is there any way I can have teh section summary lok at the rows and work out an average thereby automating it
-
Formula -
Trying to wrap my ahead around a formula to accomplish determining the top 5 $value projects in a list. I know in excel I could use the LARGE formula to accomplish this...how could I do something similar in Smartsheet? Thanks community!
-
Formula needed
Happy Thursday, all! I have a sheet with invoice dollar amounts in several cells.('Amount') Next to these cells, I have a checkbox column called 'Paid' that is checked on if the invoice was paid, checked off if the invoice was not paid. I need to total all invoice amount cells for invoices that are paid. Any tips on the…
-
Conditional Formulas
Hi, I'm working on a sheet and I'm trying to have a row be highlighted if it is before or after a set date but I can't seem to figure out the formula for that. My sheet is set up so that I have a column for the start date, a column for the end date, a column for the actual date it was completed, and a column that I will…
-
Children and Sub Children
Hello, I need a little help with formulas. I want the parent to count the children and the sub children separately. Example below. I was able get the parent to count the children but when I try to count the sub children separately it counts all the children. This is the formula I used to count the children =("CONTRACT NAME…
-
Due date PRIOR to weekend or holiday
I have a one date upon which all other due dates are calculated. We have holidays set up for the account. I need the due dates to fall on the weekday PRIOR to the due date if it is a weekend or holiday. It appears the Workday and Networkday functions fall on the following week day, which doesn't work for me. This formula…
-
Event Registration with Form & Summary
I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next…
-
splitting text into multiple rows
Hi there, I am using smartsheet for text analysis and would like to split a cell into separate rows using a return or a full stop as the separator. Any ideas?
