-
How do I use IF formula to change a color based on a percentage column?
I could greatly use some assistance with creating a formula for my sheet that would capture the following: Currently I have a sheet that contains the following data points: Quoted GP | Quoted Margin % | Actual GP | Actual GP % | GP Health $7857 35% $8970 24% ?? In this sheet, I want to be able to do the following, I have…
-
Match does not find the id but it should.
Hi Again, I'm having an issue where I'm trying to make sure that all of the right groups are listed in my sheet. for this I'm doing a simple match and if there is a match that means that the group is there. however, for some groups it says that there is no match but when I go to the row referenced and do a "ctrl f" i find…
-
Text to columns in Smartsheet
I have a cell with multiple values separated by commas. (eg. A, B, C, etc.) I want to try get these separate values in a column: eg. Row 1 - A Row 2 - B Row 3 - C and so on.. PS. There is no limitation on how many values this cell has. It can vary from no values to up to 40 values.
-
Formula Auditing/Evaluation
How do you audit or evaluate a formula in smartsheet? In MS Excel, you can audit/evaluate a formula to see the calculations for each step of the formula. I can't see a way to do this in smartsheet. I have a simple formula that should be giving me a specific value, but it's not, and I can't figure out why since I can't…
-
Capacity formula
I am trying to add to this formula "<+" &{end week}, Weekend@row =COUNTIFS({Name}, [Primary Column]@row, {Week}, start@row, {Year}, [Column3]@row, {SKill}, "LTE") * 60 I want this formula to look and see the end week and add 60 for every week of the project. Help columns and example below. Right now this formula tracks 60…
-
What formula will identify duplicates in a column and only keep the most recent row?
Hi there! Our staff fill out an "availability" form which populates a sheet with their availability for the week. I'm trying to create a formula for this sheet that will identify when a person has submitted their updated availability, and remove/hide their previous submissions. I assume the way to do this would be…
-
Using INDEX/COLLECT to return multiple values
Looking for the proper way to return multiple values using INDEX/COLLECT. I'm assuming JOIN needs to be in there but can't get it to work! Both without and with JOIN, the formula still produces the first value only. This formula matches a project number from one sheet to another, and is supposed to return ALL of the…
-
Custom Auto Number Formula
HI Community I need help creating a custom auto number formula using set prefex and a reference column. The DRN "number" or Identifier must populate as follows: ABCDE-DRN24-020T. The prefix 'ABCDE-DRN' is absolute for all numbers and the '24' after DRN is referencing the FY Reference column year. The next 3 numbers after…
-
Overallocation flag in sheets
Is there a formula or method to identify if a resource allocation flag is triggered for a given row? i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? I'm trying to figure out if there's a way to summarize all of the rows in our project sheets…
-
Using Vlookup where search value contains multiple values (column is a drop down)
I have a main sheet where i want to select "Plants for Consideration", then after selecting a production plant the emails of the people involved will populate in another cell. I've created a separate smartsheet to reference which has the column on the far left "Plants for Consideration" and then in another column (column…