-
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…
-
#INVALID VALUE Error - Can't figure out why...
I am working with two sheets. "Payment Tracker" and "Job Tracker". Payment Tracker: Auto: Auto-Number Column - No formatting Row: =MATCH(Auto@row, Auto:Auto, 0) Invoice Number: Primary Column - Manual Entry Invoice Amount: Text/number column =INDEX({Job Tracker Invoice Amount}, MATCH([Invoice Number]@row, {Job Tracker…
-
Formula to delete specific values from a multi select dropdown column
Hello. I have a COI Tracking sheet that tracks insurance by vendor, which includes a multi-select dropdown column that lists all of the job numbers that the vendor needs to supply insurance for. I have one column for Current Jobs, and a column for Expired Jobs. I have a secondary sheet called Closed Jobs that tracks…