-
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?
-
Calendar calculation (possible bug)
I am having difficulty with a calendar calculation that I use to calculate planned completion %. When dates have more than 30 days or when a non-working (holiday) is part of the month, the formula is not working as intended. Below is the formula in the planned % complete column: =IF([Planned Finish]4 = TODAY(), 1,…