-
VLookup's in Smartsheet - Are there limitations?
Does anyone know if Smartsheet has a threshold limit on the number of VLookups that can be used within one sheet? I have 7 columns with a max of 300 rows of data in a Target sheet, I am wanting to run VLookup's with to 3 different Source sheets and I want to make sure there's not some crazy limit that says your formula…
-
How to reference cell based on MAX date and another condition?
Hello! I am trying to reference another sheet that has multiple data for the same building: On another sheet I am trying to pass over the information from Column4 if Column3 equals "Cobb Stadium" and by picked the MAX Created Date & Time. So it would pass "Yes" Since the last row has the Max date and time from today.…
-
Contents of a Dropdown Multi Select Column
Hi All I need help in using the contents of a Dropdown Multi Select Column. The column has the following options A B C I want to use the actual content say AB to lookup another Smartsheet for a price for that selection. I am sorry if there is an obvious answer as I can’t find it. Thanks AV
-
Workflow to move rows with cross sheet references
I understand that if I create a workflow to move rows with cross sheet references into a new sheet, that the cells with my formulas will not maintain the reference. Is there a way to move those rows and have them retain the values only from that initial reference?
-
Adding to Inventory
I'm sure this is simple, but I've searched for a while and haven't found anything similar! I have a sheet set up to track each piece of marketing collateral. It starts w/ the beginning quantity (say 100 pieces) and deducts the number of pieces that have been requested (through a SS form on another sheet), then another…
-
Can I create a SUMIF "does not contain" with multiple values?
Trying to add up the number of people from all cities but, CityA, CityD, CityF, etc in the same argument. Is there a simple SUMIF formula i could use? Currently I have been using: =SUMIF([City]1:[City]51, <>"NYC", [# People]1:[# People]51) but i want Smartsheet to exclude multiple cities. I've tried a few options but felt…
-
Nested If Formula (Multiple Conditions)
Hello, Hoping to get some help for a rather complex nested if formula I'd like to build based on responses to a webform. Below are the conditions. Is this possible to create an if formula around these conditions to result in a a red/yellow/green visual symbol? Any help or guidance is much appreciated! Thanks so much!
-
Formula that checks if a certain date is in a date range and TRUE/FALSE VALUES
Hello! I need help on a formula that outputs a count and a sum since we are unable to build formulas from a gantt chart. This is the formula page I am using in order to build a gantt chart with a bar chart in a dashboard with month counts and sums. I created this report to show what is needed in the formula. Count: Count…
-
Different formula for a cell basing on condition
Hi All, How can i apply different formula basing on cell value? For instance i have a columns Type, Duration, Original If type = "Sub-Task" I need formula for Original "= Duration*1440" If type = "Story " I need formula for Original "=SUM(CHILDREN())" i tried IF(Type = "Sub-Task" , "=Duration*1440", "=SUM(CHILDREN())") but…
-
R,Y,G and G - Part 2
Hey @Paul Newcome / @Andrée Starå , Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request. . In a nutshell, at the parent level, I'd like the "current health" (R, Y, G, Gray) to be the color of the highest risk child (or gray if there is…