Hi everyone, I have a number of project plans in Smartsheet and am trying to get a summary of how many task hours each person has assigned for the current week. The plans currently capture task Start …
Hi everyone, I have two sheets: one is a training requests log and the other is a feedback survey. What I am trying to do is pull the "motivation reason" from the Training Requests log to the Feedback…
Hi all, I created the following formula to search through another sheet and, if a location has submitted a row in the applicable month, it is supposed to check the box on our confirmation sheet. It wo…
I'm having some difficulty in associating a date cell created by a blueprint program with the project it creates. Is there a way to change this that I'm unaware of? Setup Summary: I have a blueprint t…
I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am …
Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) fun…
I am using an INDEX/COLLECT Formula: =INDEX(COLLECT({IP}, {Site}, SIte@row, {Lane Number and Direction}, [Lane Number/Direction]@row), 1) This works great. Except for when the Lane Number/Direction is…
Hi all! I am trying to collect an average over the last 12 rows (including the current row). To do this, I created 2 additional helper columns (Line-ID and Row#), and trying enclosing the condition in…
Hello, I'm struggling with a formula that is returning an in valid column value error. All columns are Text/Number. Sheet 1 has one row for each project. Sheet 2 has a column that may have multiple pr…
I need to add an IF statement into an INDEX MATCH formula that pulls the system size of a column if it is not blank. This formula will be on sheet #1 and needs to be an IF, INDEX, MATCH. Sheet #2 will…
