-
Auto Generated Unique ID
Hello Smart Heads! Happy New Year! I am facing an issue with big data sets, missing a single unique ID. The only option of creating an unique ID is by joining content from 3 various cells, see: id is created by using simple formula: =EntryNumber@row + BLNumber@row + ContainerNo@row In a raw file (excel of course), I have…
-
How many formulas can a sheet summary hold?
I have a sheet with a hundred some formulas and I will probaby have 200+ at the end of it. Will I have any issues with that?
-
Dates - Nth date formula
Good afternoon, I have searched the smartsheets community far and wide for this answer to no avail. Would anyone be able to assist me in creating formulas for two different scenarios: 1.) I need dates for every Friday for the remainder of the year 2.) I need dates for every second Thursday and Friday for the reminder of…
-
Concatenating Dropdown Responses with Exclusions in Final Column
Hi all, I've been deliberating on this one for a while now and not getting anywhere. I have 20 columns which are single select dropdown (with the possibility to free type also). As an example, one of the column's choices are: Compliant Missing ToB ToB not initialled Incorrect ToB template used Incorrect ToB uploaded N/A…
-
Finding the most recent entry
I am having issues finding the most recent update to my list of fleets. I have read about the Max(Collect()) function and don't quite get the result back that is needed. I get incorrect column value, incorrect funciton, etc. or when I have been able to get it to run I get back a 0 instead of an actual date. I have tried…
-
Criterion not being recognized when referencing another sheet.
Hello! I am trying to count all of the values in a column that contain the letters "CC:". However, every time I complete my formula it returns with 0 as a result. How can I have it recognize this value? I have posted a screenshot of the sheet I am referencing. Here is the current formula I am trying to use. Any help is…
-
Conditional lookup to create a list from a list
Hello, This seems like a very rudimentary ask but I am stumped. Hope someone can help. Can anyone please suggest a column formula that can bring values over from a sheet based on a conditional lookup to an adjacent cell and list them contiguously on another sheet? Like so: Thanks in advance. JB
-
Need help with nested IF equation
I have an IF equation that is working fine for me, however, I would like for anything that is past due to be "Red" in the task health bar. Right now, because I have "Grey" as the first clause even if an item is beyond it's end date, if it is "0%" complete it shows as "Grey." How do I adjust the formula to make any thing…
-
Help with SUMIFS formula with two columns as criteria.
Good morning, Evening and afternoon. I am struggling with a SUMIFS formula that is using criteria from two columns. I'm not sure if this is affecting the formula or not: The column I am trying to SUM is: Collected: =IFERROR(VLOOKUP([Order Num]@row, {Dell World SKU Import Results Range 1}, 2, false), 0) My current SUMIFS…
-
Booking System in Smartsheets Forms
Hello everyone, I'm a relatively new user to Smartsheets and this is my first post. I have a question please about Smartsheets forms. I work as a videographer and I'm trying to write a form that allows people to hire out equipment (say for the sake of argument we only have one equipment type at the moment at that is…
