-
Exclude a range of values from a source range of values
Hey all, I've got Sheet 1 - List 1 that is an intake sheet with a range of opportunities (each identified by a unique opportunity number with a set number of digits) exported from our CRM program. This sheet is automatically updated whenever a seller puts a new opportunity into the CRM. I am not allowed to make changes to…
-
Dates - Due, Complete and Overdue based on Completion Date
I have a due date and completion date columns in my Smart Sheet and need help with formula to give responses based on dates. I have attached example for reference. For column with completion date being blank, would like to show "Due", for completion date before due date to show "Complete" and completion date past due date…
-
IF formula to compare due dates to show completion schedule
Hello all! I have a formula that is stumping me - I am looking to compare a target due date versus the actual completion date. I have a formula that is partially working, but am running into issues when I use the term "ongoing" on the target due date column (see Project 4 in the below example). This is what I'm trying to…
-
Overall Text Rating from a Numeric Rating/Score
Hello! I need help. This is probably basic, so forgive me, but I want the overall rating to show as the text rating assigned. For instance, 1–1.49 would be below average, 1.50–2.49 would be average, and 2.50–3 would be above average. I have messed with this for over a week and I can't figure it out. Thanks!
-
Check a Checkbox in one Sheet based on Checkbox Checked in another Sheet
I am trying to make checkboxes check in a multiple entry sheet when a checkbox in a core data sheet is checked. The core data sheet holds employee information that is referenced in the multiple entry sheet. When the employee leaves I have a checkbox to check in a column 'Employee left business' and this column is…
-
indexmatch error
I have tried the formula in office and it works fine, but not in smartsheet, why is that? It doesn't show no match or any other error, but it doesn't show the correct result!!!!!!! 😥help me please!
-
Formulaic Help / Cross-Sheet References
Bit of a complex one: Let's say I have a sheet named "Additions To Scanning Workflow" (with a select number of users) that includes 13 columns of data, one column ("Ready for Digitization Dept.") that's a checkbox field. I want the select number of users to be able to fill out this sheet and when the "Ready for…
-
How do I add age range
I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall under each age range. I have tried two ways and neither work. FIRST ATTEMPT: -The first and i think easiest is to have a…
-
How do I share a dynamic view with an external user without them saving to make a smartsheet account
I have two use cases here based on program to fill birthday bags for foster kids. Volunteers make the bags and fill them with gifts and requestors submit. a request and pick it up when it is ready. For volunteers, after the form is submitted I have extra columns I want them to follw out like when it was completed, who did…
-
Return a value from a different column
Hi, I'm quite new to smartsheets and trying to write a formula to look at multiple cells and return a value. In this example column 3, 4, 5, & 6 will either be empty or say approved or submitted but only in one cell. I want column 2 to look at 3,4,5.&6 and return the value that is there. If column 3 says approved then…