-
Setting predecessors with multiple tasks
I would like to have Task D begin when Task A or Task B is completed. How can I set multiple predecessors? Task Name | Start Date | End Date | Duration | Predecessor Task A | 7/1/2021 Task B | 7/11/2021 Task C | Start Date should be 7/1 is Task A completes first or 7/11 if Task B completes first.
-
Trying to use COUNTIFS to count Items in a drop-down column
I have a drop-down column for Issues and a column for Campuses, and I'm trying to count the number of times an issue shows up for each campus. The formula that I'm using is counting the issues, but only if it is the only item selected in the drop-down: =COUNTIFS({Campus}, "Chico", {Issue}, "Unilateral Change") Instead of…
-
IF - Date Range
Hi, Can you help me with a formula for the below argument? IF Created@row is more than 28 days In the past, "4 Weeks Overdue", IF Created@row is more than 35 days In the past, "5 Weeks Overdue" Thank you!
-
SUMIFS Across Two Sheets with Multiple Criterion
Hi All, I am looking for a the next step of this formula, I now want to include a department filter on this SUM Formula instead of all departments? is that possible =SUMIF({Timesheet Range 1}, =[Export Title]@row, {Timesheet Range 4}). Timesheet Range 1= Phase Name - Sheet 1 Export Title= Phase Name - Sheet 2 Timesheet…
-
COUNTIFS with Date range with @row
I have the current formula that counts the start date but I wanted to see if i could do a range of dates from start date to end date and count those. Any Advice? =COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], [Start Date]@row)
-
Help w/multiple if statements
Hello! I am a new Smartsheet user trying to figure out if multiple if statements work with what I'm trying to do. I would like to automate the date in the Release to SGS/Printer column based on what is in the Materials in House column and Printer column. The Materials in House column has pre-populated dates I manually…
-
IF AND OR Formula
Hi, I need a formula that will default to a specific value if two criteria are met. If "Approved" and "Not Started" Or "Draft" Change the final status to "Excluded" else use what is in the other status from Service Now. =IF(AND([Exclusion Status]@row = "Approved", [Service Now Addenda Status]@row = "Not Started"),…
-
How can I count the number of incoming calls per month using the "=countif" formula
I've had a chance to look around and found some information on being able to count the number of calls for a given month. However I'm stuck as the formula I'm entering is not working, stating it's an incorrect argument. Here is the formula. =COUNTIF({Call Flow Tracking Range 1}, >=DATE(2021, 8, 1), {Call Flow Tracking…
-
Building Vendor profiles and establishing master vendor name for match/index
We manage a lot of vendor information in Smartsheet for various projects. We are working on building a master list of outcomes for a client and the vendor name can vary project to project. As an example, one project may say, ABC Corp and another will list the same vendor as ABC Corporation. We want to analyze the outcomes…
-
Request for Update - Set Expire Date/Days
We are using Smartsheet to manage a weekly work schedule. There is a workflow that sends "Request an update" to employees the ability to pickup an open shift. Do to volume of calculations and space limitations, the schedule is managed in a a master sheet: Master sheet is a two-week (14days) schedule Planning for new…