-
Parent/Children Conditions
I'm new to Smartsheet and am trying to set up a regular monthly task list. I have certain "parent" tasks, and under each are a few sub-tasks or "Children". I have a checkbox to show that each line is complete. Is there a formula in the Parent row to check the box if all boxes are checked in the Children rows?
-
Count If - Status Symbols
I am trying to count the number of cells that have Status (Green) in my status column i am using a dropdown with Symbols Green, red, yellow. I am trying countif but don't know how to specify the 'symbol' green. Any ideas?
-
Add workdays to date
There are some columns that will be used to manage my project, "% completion", "Start Date","End Date", "Duration","Today". Now, our tasks show their completion percentage and I can see in the Gantt Chart how far the tasks run in the entire time and some of tasks seems like a bit delay from today. Therefore, I want to set…
-
Formulas- Pulling dollar values from text string
Hello, I'am new to Smartsheets and trying to pull a dollar value out of a text string to put in an adjacent column. ACI - A/CP-BP 10k Type 2 Bullet Probe | 24" Leads $6.02
-
Counting A Range of RYG Balls at Once
I have researched and tried the various formulas for counting the RYG balls in one column from 1 row through 540. I have tried various formulas but I keep receiving and error. Can someone help me by letting me know what I am doing wrong? Here are few formulas I have tried. =COUNTIF(CHILDREN([Status of Completion]1:Status…
-
formula or workaround...
Hello, I'm trying to build a sheet to use for our onboarding process. It would be nice to have on sheet for all positions. The issue is that all positions do not require the same onboarding activities. I would like to reference the job title / column and have conditions that would have the sheet only display or include the…
-
Progress Bar Automation, based on % Complete IF/THEN
I conducted a search but could not find this specific topic, so please forgive if I am repeating an existing question. Hopefully the subject line is incrementally more search optimized. BACKGROUND I am using IF/THEN formulas in my '% Complete' column to auto-populate a Progress Bar that goes into my status reports as a…
-
Hidden Rows show in Email notifications
I noticed in a new sheet format we use, which includes hidden columns calculating billing and pay rates, that the "hidden columns" actually show in totality when the user send emails from the sheet or receives their sheet notifications in their email. This is an issue since I do not wish to share that information with our…
-
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
-
How to hide #UNPARSEABLE error
Hey All, I have this formula =NETDAYS(Created16, [Due Date]16) and it's working just fine. It's just give me the number days left between two dates. But, when the data cells don't have values, it gives me this error "#UNPARSEABLE". I'm guessing I need to use an "IF" statment to eliminate this error, but I don't know how to…