-
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…
-
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…
-
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…
-
Count Days down to a due date
If I have a "Due Date" column, and I want another column to calculate the amount of days leading up to that date… what formula would be created? It would be marked "Closed" if completed and "Open" if not completed. Additionally when that item is passed the "due date" and still "Open" we would like to count the amount of…
-
RankEQ formula by group
Hi, I'm hoping to make the RankEQ formula have a criteria component to the ranking to rank overtime on deck per shift instead of by the whole group. We keep all the information on a larger spreadsheet and have a ranked report available to all staff. The column headers are below: Thanks for any help!
-
Formula to Use a Date Field and add a Number Field to return new Date
I want to use a calc on a date field, to use one date field and add a number value field to return a new date in the field with calculation. I am using =parent([SOO Start]@row+[SOO Day Duration (Calc'd 25%)]@row But I get an #Unparsable error in the field. The field I am entering calc on is a date field, [SOO Start] is a…
