-
SUMIFS with 3 conditions
Hi I am trying to calculate the total number of worked hours within a week/ month which match 2 more criteria. At the moment I have fr the monthly formula 9 September): =SUMIFS({003 Project Timesheets Range 2} , {003 Project Timesheets Range 1,"Noemi K", {003 Project Timesheets Range 3} , "Testing" and ({003 Project…
-
Nested if()
Hello great community. I'm new in Smartheet and I've a problem and even don't know if a solution exists. I'm trying to create a sort of automatized timesheet for my team. I would like them to connect to the same sheet. They have to select their name in a list ("Team" column), and the type of mission they've managed in an…
-
Change Status to "Submitted for Approval" or ""Returned to Action Party"
1. I have Action Items that can be reviewed by up to 3 Reviewers (Reviewer 1, Reviewer 2, Reviewer 3) before being Submitted for Approval. Reviewers are identified by Name. Reviews are done in parallel. 2. Some Action Items are reviewed by all 3 Reviewers, others by just 1 or 2 Reviewers. 3. After review the Reviewer uses…
-
Workflow - lock/unlock rows
Hello, First of all thanks for helping :) I have this list of tasks where i use my WFIndex + Index columns to identify them and execute automations. My Milestones are "locked", colored in blue and in this case identified by WFIndex = 4 (row 8) I have a few "checks" which i want the user to mark as "completed" before…
-
Summary Task status - automatic
Hello, Im very new to smartsheet, so, im sorry if this question is too "basic". I have a summary task with 3 or 4 children tasks. I would like to know if there is any way to automatically update the status of the summary task: - If all children are completed --> completed - If any children is on-going --> on-going An the…
-
Formula to check a box when date entered + 2 days
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. This is the formula…
-
Formula to Look Up Multiple Contact Columns
Hi There! I am creating a formula that will assign contacts to a row based on user role plus some other attributes. I am finding the look up is working great for assigning 1 contact, but when I extend the formula to include multiple v-look ups, its displaying the 2 users names as text. For example it will come back…
-
Formula Help!!!!! PLEASE
I have a data set with a bunch of dates 09/03/19 09/04/19 08/19/19 07/01/19 You get the idea.... Im trying to get a count of "incidents" by month... but I cant get the formula to work!!! July = 10 Ive tried... (below) and many others... =COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER)…
-
SUMIF on Cross Sheets
Hello, I've been trying to create a roll-up based on "Region" from another sheet and I either get "0" or invalid argument. On inventory sheet I have multiple columns with Budget, Actuals, ect and would like to sumif based on Region. The formula below returns "0" =SUMIF({Inventory Range 1}, {Inventory Range 2} = "ProServ…
-
Nested Crtiteria
Hi, I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria. =COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary…