-
Using "IF" with "And" for multiple criteria
Hello, I'm struggling with the syntax for a formula-I've seen examples within the community and can't quite get them to work properly for me. I would like to count the following: Count values where the following statement is true: column 1 =ABC, or, DEF, or, GHI AND where column 2 =123, or, 456 I've tried =COUNTIF([Column…
-
View Predecessors in Reports
Is it possible to view the Predecessors in a Report? When I create a Report from a Project Schedule, it does not show the Predecessors dependant on that task, it only shows the number of predecessors. I eventually created a duplicate column and put in a formula to copy the value of the Predecessor column and use that new…
-
What formulas would determine active proof, current task, and next task?
In my sheet summary, I would like to indicate 1) which proof is currently active, 2) the task that currently needs completed, and 3) the next task to complete once the current task is completed. *Note - The tasks to be referenced will be one of Staff Submissions (children not needed), Consolidate Submissions, Send Proof to…
-
If / isBlank statement
I am having a total brain cramp and cannot figure out the formula I need for this. two columns: Task Status Closed Date There is automation setup that when someone marks a row as Task Status = Completed, it should capture the date and put it in the Closed Date column. Well, that automation works 90% of the time, but we…
-
Symbols Formula Not Working Right
I am trying to get a formula that will put symbols in under the following conditions: If greater than 25% Blue, if between 20% and 25% Green, if between 1% and 19% Yellow, if less than 1% Red, if blank than blank. The formula I entered seems to work EXCEPT that the range between 1% and 20% is showing as Red instead of…
-
Average % Complete of CHILDREN TASKS
I am trying to get the average % complete in the parent row for all the children. Below you will see a snap shot of the work being completed, as each task is completed the PERCENT COMPLETE column will increase based on the formula in the children rows. Below is the formula in the children rows.…
-
Working days between two dates
Hi, I'm looking to use the networkdays forumla to calculate the working dates between my date column and the oldest column for each individual, I can't understand why the formula isn't working. I have set holidays to zero (and changed it to a number) and its still unparseable. Can anyone assist me with the correct forumla,…
-
Checking a checkbox if one checkbox is unchecked, another is checked and falls between 2 dates
How can I get the formula below to work? =IF(AND([checkbox1]@row, 0, [checkbox2]@row, 1, [date]@row, >=DATE(2022, 4, 1), [date]@row, <=DATE(2022, 6, 30)), 1, 0)
-
Relational Database?
Hello All, We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with each other? Some language in the site alludes to needing to integrate Smartsheet with an…
-
Sum of multiplication of two columns
Hello! I would like to get the year spend for new hires in a company based on their expected start date and percent time allocation. I have a sheet with multiple departments, salary budget, percent allocation for hires (i.e., 100%, 50%, etc), and expected start date. So what I would like to do is: For Department "X" and…
