-
Cross-referencing sheets based on date and month of value
Hello, I'm attempting to create a cross-sheet formula that inserts a date onto a target sheet depending on whether the month and date on the source sheet are between certain date ranges. More specifically, on my target sheet (let's call it sheet B), I have columns titled Spring Meeting, Summer Meeting, and Fall Meeting.…
-
How to graph a range of dates when only given a start and finish
I have a sheet where I have individual tasks each with their own start and finish dates that can overlap. They each have a certain # of people assigned to the tasks per day. Essentially, it looks like start: 5/15/23 | end: 6/25/23 | #ofPPL/Day: 5 and for each day in between those dates there will be 5 people. The goal is…
-
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…