-
IF, INDEX, MATCH formula help
I need to add an IF statement into an INDEX MATCH formula that pulls the system size of a column if it is not blank. This formula will be on sheet #1 and needs to be an IF, INDEX, MATCH. Sheet #2 will have the actual system size column and Sheet #3 will have the target system size column. The formula should pull from sheet…
-
Contact List - Extract First / Last Name?
Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there a way to only get the first name?
-
Return highest value
I need to be able to create a formula that will return the highest value based: I want it to match the Auction Item and return the highest value in the Bid column and the name of the highest bidder In this instance, I want the result to be Concealed Carry class - $100 - Becky Wilson Lydia Gillis Photography - $500 - Becky…
-
Is there a way around an Invalid Operation when using Dates generated by formulas
Hi, I am trying to use this formula =IF([Next inspection due]@row <= TODAY(0), 1, 0) then mark it with a flag. in the Flag Due Date column. Every time I use this formula I get INVALID OPERATION because the Next inspection due column is created from a formula of a formula of a date. Date6 is add on 6 months, Date1 is add on…
-
How to have status in parent row change to complete when all child rows are complete.
Is there a way to make the parent rows change based on the child rows? For instance, I want the parent row to show as complete, once all of the rows below are complete.
-
Probability and Impact Matrix (5 x 5)
Hello, I have three columns. They are: Probability, Impact, and Risk Score. The values for each column appear below: Probability Almost Certain (90% or higher) High (70% to 90%) Moderate (40% to 70%) Low (20% to 40%) Very Low (less than 20%) Impact Very High High Medium Low Very Low Risk Score Conditional formatting rules…
-
Is it possible to use =COUNTIFS when there are multiple values in one cell?
I track monthly metrics for my company. I am trying to count the number of times a specific state was completed during each month. The Smartsheet I am I need to collect this data has a multi select dropdown. I typically use =COUNTIFS({Smartsheet Range1}, "CA",{Smartsheet Range2},>=Date1,{Smartsheet Range2},<=Date2) which…
-
Pulling Averages from a Report to another sheet (Current / Prior month formula)
Hello, I currently have a sheet where I am manually pulling information from a report. From the Sheet I want to write a formula that automatically pulls information from the Report. I want one column to have "Current Month", another with "Prior Month", and the last one "YTD". (I will insert a photo of what I have. Is it…
-
Group Multiple Automations into "Folder"
Hello. I have an approval sheet with 11 categories. Each category contains automation workflows with between 5-7 steps each. My workflow window is very messy and complex. Is there a way to group each category of workflows into a "folder", or some type of set? If I can do this, is it possible to clone an entire set of…
-
I am trying to count documents and save a snapshot for a specific month
I am counting documents in one column "SHEQ Document Index Annual Review Range 2" with a specific dropdown "[Document Status]@row" for a specific month and year. However in the following month when the "[Document Status]@row" changes status for that same document, I do not want the Count for the previous month to change,…