-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Need some users to have the ability to update certain columns
Hi, We are using a Smartsheet to track order progress from start to finish. The sheet has many columns but we have 8 dropdown columns that indicate completion in certain departments...Department A, Department B...etc. How can i grant access to the leaders of each department yet protect the rest of the columns that do not…
-
Help creating formula to update inventory automatically
The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…
-
How do I create and If Formula pulling from another sheet to designate indicators?
Good Morning All, I am working on a Overall Health for a Project that looks like this: I need to update the lights by using an if statement looking at three different columns of another sheet that are not next to one another on the sheet, example of that sheet below In the first sheet for each Column I need to look at the…
-
Cell Linking Contact Lists
I have two sheets I want to link but I am having an issue with the second sheet listing the linked cell data. The original sheet has assigned contacts that I want to link to my second sheet but when i create the link, the cell does not populate. I made sure the column formats and contacts lists were identical on both…
-
Copying Column Into Blank Sheet
I'm looking for a way to copy a single column into a blank sheet. When I started the project, I assumed cell link would be perfect, but that doesn't work with the destination sheet being blank. The project I'm working on uses a form that's filled out 24 hours a day. The information from the source sheet is copied into the…
-
Unique ID
This discussion was created from comments split from: Custom Serial Numbers.
-
How to make a manual Row ID based on conditions?
I'm not even sure if this is possible but I invite all the formula wizards to take a crack at it! I have this intake sheet with 10 rows, all that have a corresponding auto-generated Row ID from the system column. Row 1 is 23-001, row 2 is 23-002, row 3 is 23-003, etc. When a project gets approved, I want another column,…
-
Formula to Return Value Based on Multiple Criteria "If-And"
I'm trying to write a formula to return a value based on multiple criteria. I've gotten other similar to work, but this one is not returning the correct value for some reason (or not clearing the value to a blank ("") when it should). The value I'm trying to have the formula return is "Open Go-Back - Corrections Submitted"…
-
Count Project Question
Good afternoon, We have various different 'centers of excellence' that our team supports for projects. Some projects may be overlapping between the centers of excellence, while others may just be specific to one singular center of excellence. Overall, we have 26 projects altogether being worked between the different…
-
Conditional Formatting To Red out a Row, if ID# has been used before
Hi all, I am trying to create a conditional formatting to mark a row Red if the ID# has been used before. I have plenty of conditional formatting experience however I just can't seem to figure this part out. Basically in a list of projects I.e 1,2,3,4,5 they move at different speeds and sometimes a project wont be on a…