-
Progress Bar Automation between 2 Different Sheets
Hi to all you brilliant Smartsheet Wizards! 🧙♂️🧙♀️ I saw a question on here regarding how to "automate a progress bar" and I thought that is perfect for my tracking: Automate the Progress Bar — Smartsheet Community My problem: I want the progress bar in Sheet A under "milestones". But I want it to source the data from…
-
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…