-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Recruiting Metrics
Hi SmartSheet Fans, Wanted to start a discussion with the community revolving metrics and how you've used SmartSheet to get you recruiting metrics (time to fill, 1st touch date, etc.). Since everything is date related we created formulas to help us, but would love a different approach if anyone has any. Thanks! Kris
-
SETTING REMINDER DATES
Hello to all, I'm completely at a lost with formulas in Smartsheet because they are based on column name and location rather than cells like typical spreadsheets. The examples I find in the help are never similar to what I need, can someone help me please? We have a column for Date of Request and Due Date. Reminders are…
-
Duration setting end date based on 8 hour day, not 10
I changed the length of the work day to ten hours in the project settings. When I set the duration for a task to 1d, the end date changes to the next day. If I change the duration to .08d, the end date is the same day as the start date. Is this a limitation of the trial verison? thanks
-
Invalid data type
Hi I hope someone can help with a very frustrating problem. I have a sheet which is used to calculate work progressed. It takes the number of checked items in a column and sums them using the COUNTIF formula "Actual formula is ="" + COUNTIF([240mm Term]5:[240mm Term]171, 1)" The cell underneath this take this value and…
-
Reporting from multiple sheets
Is there a way I can run a report from multiple sheets? I can select 2 or more sheets but it's an "OR" and not "AND". So, the report isn't reporting on all selected sheets. Or, am I missing something? Thanks!
-
Formula Referencing Cell Populated by a Formula
Thank you in advance! John
-
baseline - actual dates
This post is in regards to this post below. I would like to get in touch with Jeremy michels to see if he will share the sheets he references with me.Any help will be appreciatedThanks so muchLouise Jeremy Michels601 ptsApril 5, 2015 8:30 pm I do the added columns now. We use it for both schedule and budget reasons. If you…
-
Creating a Summary View Sheet
I have a sheet which has information on Projects and Activities my team are working on across the whole of my region. If has columns such as Activity Title, Person, Region, Partner, Status This shee it great but I would like to create a linked sheet which gives me total counts for each for each Person I would like to know…
-
Critical Path During a Project
I can't seem to get my Smartsheet to re-calculate critical path after a critical path item is complete. The critical path should change as items are compeleted. What tells Snartsheet to no longer look at a completed item so it can re-calculate the new critical path during a project?