-
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…
-
Need Help with Formula, want all project summary sheet to record most recent step completed
Hi I have a summary sheet that contains all projects that my various PM are working on, the project summary sheet looks like this: Each project then has its own sheet for the PMs to keep track of what steps have been completed for the project, looks like this: On the summary sheet in the "most recent step completed" column…
-
IF THEN formula
I'm trying to incorporate a formula in one of my sheets. I'm going to use terms as if I were referring to Excel since I'm still getting familiar with the terms in Smartsheet. For example, if cell A2 contains a date but cell B2 doesn't have a date then I want the value in cell C2 to return "50%". If cell B2 contains a date…
-
How can I connect multiple sheets into 1 master sheet?
I have multiple sheets, each populated by their own form. I would like each sheet's columns imported into the master sheet and populate the same row. Is that possible?
