-
CountIF for whole column Not just a range of rows
I'm trying to count the numbers of "text a" appears in an entire column. This is the formulas I'm working with, that both produces an unparseable error are: =COUNTIF(contains("Resident Instruction", [Resident or World Campus Offering])) =COUNTIF([Resident or World Campus Offering], ="Resident Instruction") What am I doing…
-
Maximum number of cross-sheet references per sheet
Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together. I am about 90% of the way through and just encountered the below. The way my sheet has been structured makes it impossible…
-
How to Populate Row based on cell option from separate sheet?
I’m looking to populate an entire row on a Smartsheet based on the cell option that is selected from a drop-down menu in a separate sheet. Specifically, I want to populate the row in the Master sheet with the information from the row in the sheet that contains the drop-down menu. Thank you.
-
Overallocation flag in sheets
Is there a formula or method to identify if a resource allocation flag is triggered for a given row? i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? I'm trying to figure out if there's a way to summarize all of the rows in our project sheets…
-
#DATE EXPECTED error in COLLECT
Greetings I have been trying to figure this out for a couple days now. Let's say I'm trying to get expiration dates for fruits, which is 1 week after they are bought. However, if I have two apples (initial apple and follow-up apple), I'm only interested in the expiration date for the initial apple. After a lot of attempts,…
-
Counting instances of a request that meets certain conditions but it's not counting sequentially?
Hi, I'm trying to count the number of times a request appears that matches certain conditions. I want the first instance it appears to be 1, and the second instance to be 2 and so forth. Right now, this is what I'm getting when I filter for the requests that meet the conditions I'm looking for. I don't know why it jumps to…
-
I am trying to create a column with all emails associated with a certain name in the column
HI, I have a problem where I need to give access to certain rows of information to people in the same group. I have a smart sheet set up right now that looks something like this. I am looking to put all of the emails in group 1 into the access column so that I can have only people associated with the group to be able to…
-
How to use if contains with similar words
I want to use if contains to find a word and classify it The problem I have is they are to similar it will always Classify it as A and not B. the description is to long for Has or just a regular if Statement. =IF(CONTAINS("EOR", description@row), "A", IF(CONTAINS("BOR", description@row), "A", IF(CONTAINS("CBOR",…
-
Text to columns in Smartsheet
I have a cell with multiple values separated by commas. (eg. A, B, C, etc.) I want to try get these separate values in a column: eg. Row 1 - A Row 2 - B Row 3 - C and so on.. PS. There is no limitation on how many values this cell has. It can vary from no values to up to 40 values.
-
How to create a dashboard from a client smartsheet project
We are working on a system conversion. The project is in Smartsheet but owned by the new system company. They've not been able to provide the level of reporting my SLT is requesting. How can I create a dashboard from that project without doing any changes or calculations, summaries within their project? They did make me an…