-
CountIF Formula for Dates in the Past
I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula: =COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of cells that have a date so my team can track how many animals we have enrolled in a certain project. I want to change this to…
-
Formula to calculate working hours
Hello Team , Please see attached photo above Im looking for away to count my employees daily working hours (in working hrs col) The Col names ( Shift Start and Shift End) are select down menu for 24/hrs (hrs and minutes separated with colons) I Need a formula for column (Working/hrs) that count the number of employee's…
-
SUM IF with OR Criteria throwing Invalid Operation error-what are we missing?
I am trying to count a number meeting hours for each leader, but only meetings they lead or are mandatory to attend. I have been trying to get this to work for those 2 types of 'status' and I must missing a nuance somewhere. Thanks! =SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG",…
-
Formula for projects completed by month
Im looking for a total # of projects that are completed by Month and year
-
Fast status updates based on parent cell
I would like to make our status updates faster by utilizing the parent/child cell(s). If the user changes the status in the parent cell (dark grey line) to "Completed" then the child and grandchild cells would change to completed. If the user marks the child cell as one of the following statuses then the grandchild rows…
-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
Trying to lookup most recent
Hi New to smartsheet So my goal is to lookup only a value from the most recent row in another sheet and preform a calculation Example. What I am trying to build is a countdown to Preventive maintenance for some of my fleet vehicles as entered on forms The idea is when row 1 on this sheet is updated (oil change preformed)…
-
Automatically Include Current Date in a Form Field on Templates
I have a form I use for data collection. In one form, it has a start date which would always be the current date. I cannot find a way to have the template always use the current date the form is generated. Instead, I have to edit the form each time I use it to add the current date, then make sure it is hidden on the form…
-
Auto Date on Forms
Does anyone know how to have a template form automatically use the current date? I have a form I use for collecting data and it has a start date, due date, etc. I would like it to automatically use the current date as soon as the Smartsheet is generated from the template. Is that even possible? TIA
-
Index Match or Index Collect with multiple criteria
I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row, {Scope of Work}, [Scope of Work]@row)) Solutions? 😁
