-
Strange behavior with autocomplete today (unexpected, erratic)
Some formulas auto completed today. Some didn't. Or appeared to move down a single row maybe? I don't see a pattern just yet. See uploaded pics. Notified support as well. Anyone else experience this? I'm off to correct 1k plus rows...
-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
Need formula to count rows with a text character in a number string, within a date range
I would like to write a formula to count how many times a text character appears in a number string, within a specific week of the year. My JOB # column contains many project numbers (63254C, 63255C, 3235M, 63256C, 3236M... etc.). I would like to know how many "C" characters I have in that column, and how many "M"…
-
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…
