-
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…
-
Searching a column in another sheet
Hi, I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or something that can search another column in real-time as I type. An alternative would be a drop…
-
using if functions to perform multiple logical evaluations
I am needing to look at one cell to see if it has a specific word and then if it does use networkdays to calculate using two other cells. I am able to do this in excel, but unable to find the correct formula to do in smartsheet. Below is an example of what I used in creating it in excel.…
-
Formula / Function to copy cells from one sheet to another
Does Smartsheets have a function or formula that will copy a cell from one sheet to another without the manual copy/paste process? For example, I have a sheet (CDA 1) that will be used to scan a barcode into a cell (Column2 - Row1). I have a second sheet (CDA 2) that I want to auto-populate what was scanned into the cell…
