-
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…
-
Double check my formula
This formula turns the Harvey Ball gray even when there is a blank child. What am I missing? =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", IF(COUNTIF(CHILDREN(), "Update") >= 1, "Update", IF(COUNTIF(CHILDREN(), "Gray") =…
-
Cell linking within the same sheet
I have a project where I have a start date and due date for each of my tasks, however on a calendar report sometimes I want the start date to show up on the calendar (when it GOES to reviewers) and sometimes I want the due date to show up on the calendar (when the analysis needs to be COMPLETED). I've created a summary…