-
Exporting a comma separated set of numbers in a cell to an indepedent set of columns
Hi All, I have something like this in a column QCEVCODE: 1,3,2,5,1 for let's say 1000 rows, each one of them is the amount of issues for a type of dataset. I need to be able to export this to independent columns (or any other way to happen to come across with) so i can build a diagram, graphic showing percentage of certain…
-
Formula to automatically link Week to Date
Hello, we have individual production schedule sheets where we assign hours against weeks. We want to create a column that will autofill with the Date it is starting based on the first Week Number column that has hours in it (example attached). We have this working with a long formula: =IF([wk 23]@row <> "", "06/06/22",…
-
Another formula question
Please could someone help to show me where I have gone wrong? I have been through this many times and cannot see why I am returning "Incorrect Argument Set". =IF(AND([Column Name]@row = "Link Active & Works", [Column Name]@row = "Link Active & Works", [Column Name]@row = "Link Active & Works", [Column Name]@row = "Link…
-
Date Formula - Text Number Column
Hi, I'm trying to create an automation when a date is reached, but I have had to change my date columns for the formula to work. =Date@row + 5 of days, when this date is reached I want a workflow to start, but the automation doesn't identify it as a date field. Is there a way to overcome this?
-
Some type of look up formula needed
Hello Experts! I have a sheet that is compiling a lot of project information for P&L purposes. I need to find a formula that will enter the Project Manager for a Job number (each time it appears). I think the best place to pull that from is my project intake sheet. Please see below screenshots. Can someone recommend a…
-
Stoplight for Project plan tasks
Greetings! New to SmartSheet formulas - so need help on some of the basics, I guess :-)... Logic / Pseudo required: Formula below tested but could not be parsed: =IF([%Complete]@row = 1, "Blue", IF(AND([%Complete]@row < 1,[BSLN_Finish1]@row < TODAY()),"Red", IF(AND([%Complete]@row < 1,[BSLN_Finish1]@row > TODAY(),AND…
-
Return task description for next task due
Hi, I'm trying to return the task description for the next task due on a project plan. Right now I'm using =JOIN(COLLECT({Project Plan - EOL Asset Enterprise Range 1}, {Project Plan - EOL Asset Enterprise Range 4}, @cell < 1, {Project Plan - EOL Asset Enterprise Range 6}, @cell = 1, {Project Plan - EOL Asset Enterprise…
-
Combining IF statements
Hello, I need some help with combining is statements. I have one column which has two types, that is, Type is the column name and you can choose Type 1 or Type 2. IF it's Type 1, then I would need Primary Name column to return and if it's Type2, then I would need Secondary Name column to return. I was trying this…
-
SUM and INDEX combination formula
I have this formula that works in Excel, but when I try to rebuild it in Smartsheet, I'm getting an error that it's unparseable. How can I do this in Smartsheet: =SUM(C3:INDEX(C3:N3,$C$2)) I've gotten here in Smartsheet, but it doesn't work: =SUM(January@row:INDEX(January@row:December@row, 1, $January$1)) I would like to…
-
I need help writing a report that contains the parent and all child rows.
For every project (parent row), I need to write a report that pulls the parent and all child rows. This report needs to show all the children and designated columns. I got the report to run, but it only pulled the parent row. How do I get it to pull the children with it please?