-
count tasks "on fly" per work week.
Hello Gentlemans , Do someone can give direction on how to count tasks "on fly" per work week. Example; task start 28.07.20 finish 28.08.20, this task will include in count WW31,32,33 and 34 till its finished. task start 10.08.20 finish 20.08.20. ww31 ww32 ww 33 ww34 1 task 2 tasks 2 tasks 1 task
-
CountIFs
Hi I am trying to do a count if to see the following if the value selected is Milestone and the status selected is Complete at the moment I have tried this =COUNTIFS(Value:Value, "Milestone", Status:Status, "Complete") but its returns an unparsable or circular ref and the also blocks the formula I have to see the total…
-
Can I set the default value for a drop down list to be a formula in a form?
I am creating a SmartSheet whose rows are filled with the submission of the form and I wanted to utilize the hidden feature of the form to autofill a field when the form is submitted. I wanted this field to hold a formula that would select a value from a dropdown menu upon submission of the form but every time I submit the…
-
Formula to update a cell
I want my column for progress (Not started - In progress - Complete) to update when someone adds the % complete. So is "0" then read "Not Started", If < the 0 but not 100% then "In Progress" and if 100% then "Complete". Does anyone know that formula?
-
Parent Row % Complete Doesn't make any sense
See attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me. There is a formula for Target % complete: =IFERROR(IF(Status@row <> "Completed", IF(NETDAYS([Today (hidden)]$1, [Planned End]@row) /…
-
Formula to return the logged in user
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODAY(), "")can we have something like =IF(Closed1 = 1, Logged user, "") I know that there…
-
Find most recent updated status for category
Hi all, I'm searching for a solution on following idea: I have a sheet with following four columns: Created (date) | Category (Dropdown) | Previous Status (RYG balls) | Current Status (RYG balls) Now I want to auto-populate "Previous Status" with the last "Current Status" of the same "Category" when a new row is entered.…
-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Multiplying Cells in an IF statement
Morning Smartsheeters.. Was hoping someone could shed some light on why this statement isn't working.. =IF(Part75 = "Labour", [Supply Price]75 * [Quantity]75) I'm trying to multiply two cells based on whether the labour cost is Labour, or Labour O/T.. but I'm getting an INVALID OPERATION FAILURE. Thank you.
-
Auto-assign contact based on department within a form
Hello! I have a form for project intake work where the end user has the option to specify in which department they feel their project should reside (for example, DBA versus Phones/Communications, etc.). I'd love to use INDEX/MATCH to auto-assign a PM based on what that department is e.g., DBA = Johnny Appleseed,…