Hello - I am managing a Smartsheet action item log. I need any row that is deemed 'complete' to be moved down into a completed section further down the sheet. Is there a way to set this up to be automatic vs.
I am trying to create a Gantt chart that tracks a project in terms of days, not dates. For example, Task 1 will run from Day 1 to Day 5, Task 2 from Day 3 to Day 9 (instead of August 3rd- August 8th). Is there a way to do
I am running a report and using a Star symbol to filter what should be picked up from my sheet. The report is picking up all rows with stars checked except one. I have confirmed this row is checked. I have removed the Star filter to show all data and it works just fine, picking up this row. But when
When you lock a column, is the person that created the form the only person that will be able to update that column? I have a column that I want one of the people that I will share the report with to be able to edit the
Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says