-
Multiple IF Statements -- Status Updates
Hello, I am trying to put together a sheet that reflects as a holistic "Status Update" depending on whether or not something has been "Approved", is "Pending", or has been "Denied". I attached a photo that shows what I am trying to get my sheet to reflect and what is happening with returned values. Here are the examples of…
-
Multi-Select & Automated Notifications
I'm trying to create an Automated Workflow for Requesting Budget Updates. We some times have to send out Update Requests for Monthly Budgets - obviously the number of months will vary client to client. My question is - is there a way (using Conditions, Formulas, etc.) that I can setup one Automated Notification that would…
-
Hide #INVALID VALUE or Display Alternative
Hello! I'm using MATCH with COLLECT to return a value based off the two criteria of an ID and Today's Date in an "Intake Sheet" populated from forms. This data will be populated daily and I would like to: hide #INVALID VALUE when there is no value or display something such as "No Data". =INDEX(COLLECT({DailyUnits},…
-
Referencing data from other sheets
I need to create a sheet (let's call it Sheet 1) that references data from several other sheets IF a certain box is checked in those reference sheets. For instance, If the box is checked in any row of column B, Sheet 2 or column D, Sheet 3, the data from the Name, Date and Amount column for that row in those sheets would…
-
Move Rows to Another Sheet...that contain formulas
Hello! Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved over during a workflow.
-
If/Then copying cell information
I'm sorry if this is posted- I haven't found an example from previous posts that is working for my situation. I have 2 name columns- [First & Last Name] and [PI First & Last Name], and a third column for 'role'- [Study Role]. If the person picks the role I need (PI) I'd like copy the name of the 1st name column to the 2nd-…
-
Text/String Version of Max formula
I have a sheet where I am writing rows and not all entries will update each column. I want to reference that column on another sheet and only return the value that is not blank. I can't quite get the ISBLANK formula to work for this. I've done this with dates using =MAX(range). Not sure how to accomplish with text. Thanks…
-
If 2 criteria are met in 2 columns then sum a third column formula
Hi All, I had such great luck with help yesterday, I thought I would try again. I need to sum a column if 2 other column with specific criteria are met. This is the formula I have tried but it is not correct. I get UNPARSEABLE error. =IFS[Vendor Name]:[Vendor Name], "Curium", [Claim Status]:[Claim Status], "Pending - With…
-
how to get a form on smartsheet to automatically send to a certain manager based on type
In a recent video that was posted by John Cicero, he spoke about having the form automatically update the sheet with which manager that intake request should be submitted to. He used a "Match&Index" formula, although he did not show us the steps on which how he did this. I tried to read the help pages on Smartsheet showing…
-
show only date vs date time using Concatenate formula
I am using the formula below to display 2 dates in a single cell but its displaying "date time - date time" vs just "date - date". In the original cells only the date displays (no time). Any suggestions on how to set the formula? =[Start Date]49 + "-" + [Actual End Date]49 currently shows 10/6/2020 8:00 AM-10/08/2020 4:59…