-
Text To Column
I need help taking this string of text and creating column for each unique number sequence that is separated by comma. I was able to do the first column, but I'm unable to figure out the rest. Any help is appreciated.
-
How can I find the Unicode for a gray circle so I may use it with the UNICHAR function
I'd like to expand my RYG list to include gray in addition to red, yellow, green and blue. But how do I find the code so that I can use it with =UNICHAR(XXXX)? My current formula is: =IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow",…
-
Cross-Reference Formula Help with IF Statement
Hoping someone can help me fix this formula: =IF({Scope & Proposal Master List status column referenced} = "Won", INDEX({Scope & Proposal Master List project name column referenced}, MATCH([Project Name]@row, {Scope & Proposal Master List Status}, 0))) I have two sheets. In the "destination" sheet (Project Wins) I have a…
-
can i use index collect to find a value based on a date?
through use of a form i have a sheet that will create rows with certain departments and issues they've encountered. i have a master sheet that i want to populate with the most recent issue encountered. My thought is the first find the max date for a department and then use index(collect to collect the first issue that…
-
Cross sheet refrence formulas on a metric sheet keep showing errors until the sheet is opened
I have 5 large sheets (10,000 rows, 45 columns) mostly populated by DataTable that I'm collecting metrics from on separate metric sheets (1 DT sheet → 1 metric sheet). The metric sheets collect the metrics via cross-sheet references. Some of the formulas "break" (breaking the dashboard visuals) but quickly fix themselves…
-
Sum of Parent and Child but also provide the Parent data when no Child present
I would like to calculate the Sum of the Parent and the Child data under Number of Compounds Tested, however I do not always have a child and only a Parent at times. I did create a Helper Cell Hierarchy but cant seem to find the correct formula. When there is a child, I do not want any sum calculated in that row as for…
-
SUMIF statement failing with INCORRECT ARGUMENT SET
Hello all, I will state up front, understanding the syntax is still challenging for me. I have a SUMIF statement as follows: =SUMIF({Product Helper}, "1st", {Product Estimate}) What I'm trying to achieve is to total a column in another smartsheet if the product helper from same smartsheet = 1st. Any help appreciated,
-
Conditional Formatting Comparing Dates
I want to have conditional formatting comparing 2 dates: Where [Actual] > [Due Date], column will be red Where [Actual] < = [Due Date], column will be green Where [Due Date] has a value but [Actual] is blank, I would like to assume today's date for Actual. Where [Due Date] is blank, but [Actual] is not, I'd like it to be…
-
Formula to capture % of boxes not checked
For new hire training there are several items they must complete for training requirements to be met. I am trying to figure out a way to show % uncomplete for all open training items (boxes in red that are not checked). Is there a formula to capture % not completed for the entire grid and then a % not complete for each row…
-
IFS statement with a date from another cell
Hi, I am trying to create a formula with dates that will change each month to the start and end date of the new month, so I was hoping that I could link the start and end dates to a cell in the Smartsheet which have the correct dates and will be easy to update rather than changing each formula each month, but when trying…
