-
Forcing duration and start date to a specific value on Gantt
Dear Community, Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'? We are tracking key milestones and are only provided the End Date. I'd like to reduce the manual entry to automatically make the Start Date match the End Date and ensure that the Duration…
-
Returning a YES value
Trying to get a formula to evaluate 2 columns and if the 1st column is CURRENT and the 2nd Column is CHECKED, return a value of YES, and if either column doesn't show the CURRENT of CHECKED, return a value of NO. Have tried many combos and think I'm close - what's missing or wrong here: =IF(AND([Ins Status]@row =…
-
Graphing Data
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown…
-
Tick a checkbox depending on value of another field
I have a multi column Smartsheet that tracks items by date. Part of the functionality shows the number of days the item has been active:- =IF(OR([S.Status]5 = 3, [S.Status]5 = 1), TODAY(0) - [Start Date]5) There is also a check box column. What I would like to do is to automatically tick the check box if the number of days…
-
Counting active projects by quarter
Hi I need to count the number of projects that are active in each quarter by business area. I have a start and finish date. The will run over multiple quarters. I have used this formula but this seems to only pick up what is active in this date bracket but does not include the projects that for example run from 12/1/19 -…
-
Identifying current week for milestone spanning several weeks
Hi community, I'm looking for help on identifying milestone tasks that span multiple weeks (see screenshots below). Our project plans have a "weeknumber" helper that checks the END date of a milestone task to set the week number. I then use an Index/Match in the Summary Sheet area to identify the Milestone task name for…
-
Rostering for Global Customer Support
Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call. Also, includes our contractual obligations with customers in an easy display view to the eye. Do you think…
-
Help with formulas using contact list
I am trying to create an "Assigned To" sheet for each employee. I would like to pull from a contact list column on another page. I want it to return "Alex" if Alex is listed in the column and reference "Job"@row, if column has other names or blank, I would like it to return blank. Is this possible? Ex: On empty sheet…
-
Dashboards & Formulas
Hello, I have (2) fields on a sheet that are driven by dates. here is an example: =if(and(today()>=date(2019,9,1),today()<date(2019,10,1)),"Period 1") So on the first of each month, this field on my dashboard should update to the current month. For some reason, the dashboard will only update if the sheet is opened. is…
-
Simple IF OR Formula
Hi, I would like for the 'Invoice to Cust' Column to update to "No" WHEN 'Cost Recovery' is either "Blank to Invoice" OR "Operation to Invoice". ^Apart from this, if it is doable; I would like to add to this formula of WHEN 'Status' is "To be Invoiced" will update 'Invoice to Cust' to "PENDING" However, if the last ask is…
