-
Syntax Error
=IF(AND([Engagement Phase]:[Engagement Phase]="COMPLETED", [Production Status]:[Production Status]="Production Ineligible") 0,1) I am sure its something minor.. But just not able to fix this.
-
Problems with using formula to count items in drop down list
Hi I am hoping you can help me out here. I am trying to create a pie chart on a dashboard to display the proportion of technology types that are being serviced. This is a drop-down list with 5 different values. I read it is easiest to count the values individually in the Sheet Summary and then use that to create the chart…
-
Returning Yes/No Value based on date columns
I've tried multiple ways of putting together a formula, but I am stumped! The Excel version of the formula is not translating, so I'm not sure where to go from here. Basically I'm trying to use IF/AND to see if Column 1 is < 09/30/2022 (or whatever the last date of a month is as I update it), and Column 2 is >09/30/2022,…
-
Return line's value based on multiple criteria
Hello, I am looking for help in returning a particular cell's contents based on multiple criteria. I have two sheets I am working with, Primary Sheet and Data Sheet, where I will be searching for the criteria. Below is a snippet of some dummy data. I would like to write a formula where I return the value of the Work ID…
-
Form Automation
Hi, My vision is, that when a form is submitted, it is placed into the appropriate bucket based on the person assigned. For example, a new task is submitted for Austin via a form, when submitted, it is placed in row 1. I would like it to move into Austin's task area automatically. Is this possible?
-
Combining Multiple Formulas
Hello, Trying to help a co-worker out with combing these formulas into 1. She thinks adding AND is the solution but i was not sure. Here are the formulas broken out below that we need to make into 1 formula. =COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Consolidated Backlog Range 2}, @cell…
-
FORMULA HELP? max/collect/if
I am trying to get information from another sheetA to sheetB I want to bring the MAX {MVMG} month vs month growth from sheetA to sheetB if the depot column on sheet A {depot} = depot@row sheetB Lack of sleep ... I have tried all sorts of formulas any suggestions welcome and much appreciated 🙏 Please bear in mind new rows…
-
VLOOKUP only works with the raw data, not with another sheet that uses the same source
Hi all, I need your help to understand why VLOOKUP is not working in a seemingly peculiar case. But it might just be a difference between Excel and Smartsheet, as I'm a Smartsheet newbie. I have two reports, originally it was built like this: Report 1 - draws from original raw source data file, output column 10 Report 2 -…
-
How to include Count Collect formula with Parent Row Count Formula?
Hey there, I'm trying to add a 'Count Parent and other rows' formula to my existing count collect formula. See existing formula below. =COUNT(COLLECT({Row ID}, {Category}, $Label@row)) It is counting specific fields from the intake sheet and placing in a newly created sheet. To update it I want to exclude child rows from…
-
Only show calendar text (Primary Column) if other column = X
Hi, I’ve got this Primary Column for publication in our calendar: =([Event Title]@row + ", kl. " + Start@row + "-" + End@row + ", " + [Contact Name]@row) I’d like to only show this if dropdown column ”Booking” has the value ”Verified”. If dropdown column "Booking" is anything else, I'd like the Primary Column to be empty.…