-
New Row Formula Issues/ Default New Row Feature?
I'm looking to take a Smartsheet I created for my department and to share it with other teams. It's fairly simple, but I have a few formulas doing some stuff: * A Status Ball that syncs with the status text. * A formula in a PARENT_PROJECT =(PARENT([Project]@row)) that syncs with the Parent Project name so that I can use…
-
Harvey Ball Formula
Needing a formula to turn Harvey Red, Yellow, and green. If sold box is checked = green. If Quote Submitted day is over 14 days, AND sold is NOT CHECKED = yellow. And if Quote submitted date is over 30 days past, AND SOLD is not checked = red. I have the green part correct =IF((Sold@row = 1, "Green"). Having trouble with…
-
Hyperlink to a server (referencing cells that tell it where on the server it is)
Good morning, When I use excel, I have the ability to combine several cells together using the "HYPERLINK" formula, and am able to get a link generated automatically where it will point to an outside server and folder I'm working with. Excel does it perfectly, but I'm using SS to track things within a team. But it's 2…
-
Check the box if it's a Monday
I have a [Due By] date column and a [Monday] checkbox column. I'm trying to create a formula that will check the box on any [Due By] that is a Monday. I got as far as getting the box to check if today is Monday: =IF(WEEKDAY(TODAY()) = 2, 1, 0) But can't figure out the rest. Thanks for your help!
-
New Formulas Feature: Reference Data from Other Sheets!
You can now reference data from other sheets in formulas! Create a master lookup table sheet and use VLOOKUP to find data on another sheet. More information on this new feature is available in our help center: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
-
Checkbox in Column if RYB is Red or Yellow, Not checked if Green in Risk Column
Hello, I am new to using formulas and am struggling with trying to automatically check a checkbox in one column if, in the Risk column, the RYG risk is red or yellow, not checked if risk is Green. I am able to get the following formula to work for red and yellow: =IF(OR(Risk1 = "Red", Risk1 = "Yellow"), 1, 1) I am not able…
-
Request type by project
Hello, I'm having difficult trying to report on metrics that would outline the following: Identify the number of request types by project For example, if you have 5 projects, all named differently and 2 request types (new/existing) and you wanted to report in a sheet, to then carry over to a dashboard the number of…
-
Cross-sheet formula
I would like for sheet to auto populate certain fields based on entering in a "property name" When I enter a property name, I would like for it to access the fields from another sheet that has that property name, and input values for that property. would I use a =vlookup? Thanks for you help! SGF
-
Wanting to pull "today's data from a column
I have a spreadsheet has data related to customers orders by accounts, status and dates. This spreadsheet feeds a roll up sheet that rolls up the information from the base spreadsheet. I then take that data to feed a dashboard. I need a formula I can put into the roll up sheet that pulls all the orders that are scheduled…
-
Help! Trying to edit the automation of RYG balls!
Hello All! I am stuck trying to fix the automation of my RYG balls in Smartsheets! I need to add one more IF formula to be the formula below so that if a task has not yet been started, the ball will show up as gray. You can see from the screenshot below that all the other balls are working except when the task has yet to…