-
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? 😁
-
Look up Contacts from Cell on Sheet
I've got a bank download that has a user name in "Last, First" format and I'd like to look up the Contact so I can e-mail the data to that contact. Any suggestions? Appreciate it! Brent
-
Revise current formula to add IF Statement
Hello again! First, thanks for looking, and thanks even more for potentially helping, it is greatly appreciated. Okay, first, I have a working formula (wooohooo)! Okay, I now need an additional IF Statement added to my current formula, and this is where it gets tricky. The first screenshot is where my formula will go. The…
-
IF formula , with item found on another sheet
Hi, I am trying to create a formula. i want to return a patient's status based on if that patient is found on another sheet. I have 2 sheets list of active patients available cases 7.6 I have a an admission ID on both sheets which can be used in a vlookup type of formula. if the admission ID is found on the "available…