-
At risk flag automated
Hi all, I would like to automate my 'At Risk column' via a formula. The flag should be red if Due date is in the past AND if Status is NOT 'completed' 'or empty) I am using this formula: '=IF(Date@row < TODAY(); Date@row <> ""; 1)', but it is not working correctly. What is wrong with this?
-
Help with IF / CONTAINS Function
Hi! I am trying to write a formula that will look at a description column, see if it contains a specific string of text, then return a list of adjacent cells where the formula is true. Said another way, I want to type a string into a cell (A1), look at the description column on another sheet, then return a list in column B…
-
Counting records
Hi, I'm creating a form to capture data that includes the name of the person completing the form. The info on the form will then be reviewed and categorised. What I want to do is count up the number of times a named person appears and also do this by the various categories. The problem I have is that, whist I know the…
-
Remove comma from extracted text
Hi, I am using this formula to extract the last name from a name but it includes the comma. =LEFT(Name@row, FIND(",", Name@row)) How do I remove the comma? I tried =LEFT(Name@row, FIND(",", Name@row), - ",") but that didn't work. Thanks, C'loni
-
Real-time Update for Sheet Summary
Hi, I have a sheet with months as columns. I have a formula to calculate monthly percent compliance when the numerator and denominator is entered into the sheet. For my sheet summary, I would like to see it update in real-time with the latest average percentage calculation, meaning it would show the average of percentage…
-
Duplicate Values For Columns with Hyperlinked Values
I've found a formula to indicate whether there's a duplicate value in a column, which is great. However, it appears Smartsheet does not recognize any cells that are hyperlinked so the formula treats this as a negative, even if the values are identical. I've noticed other issues related to hyperlinked cell values like when…
-
How can I set paragraph line spacing in Document Builder?
I have a series of documents that I have mapped in Document Builder. I need to have the end result with a set line spacing to match the rest of the text from the PDF. I cannot find this setting. I know that I could hard code in the line breaks in the formula, but my issue is that the values in the formula are of variable…
-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
Stop counting NETDAYS formula based on date in another column
Here are the column names in my sheet that pertain to my question: [Address By Date] [Days Remaining / Overdue] [Date Resolved] The column formula is in the [Days Remaining / Overdue] column and I want it to stop counting when a date is entered into the [Date Resolved] column. The current column formula in the [Days…
-
Multiply Different Columns w/ IF(Or
I'm using the above formula to multiply "MSRP x Final Launch Qty" to find the Project Launch $. But I'd like to revise the formula to include" If 'Final launch qty' is blank, multiply MSRP x Brief Qty" Any advice on creating this formula?