-
Dropdown list creation from existing columns
I have a database of our company standard operating procedures and I would like to have a webform which allows all of our staff to recommend a revision to a specific SOP. I think I would like to create a dropdown list from an existing column, but it looks like I'd have to type them all in individually to create the list.…
-
Auto Fill Dates
I am trying to have cell automatically fill the following dates: * First day of the current week (i.e Monday) * Last day of the current week (i.e Sunday) * * First day of the next week (i.e Monday) * Last day of the next week (i.e Sunday) * * First day of the previous week (i.e Monday) * Last day of the previous week (i.e…
-
Reverse Engineering a Timeline
Is there an easy way to reverse a timeline that was originally based off of a start date, but should be based on the end date? We plan a lot of meetings where the meeting dates are always moving and we want to adjust the way we have our timelines so we can change the meeting date and Smartsheet can fill in the dates of the…
-
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
-
Update End Column When complete is mark
Hi there I will like to know ...is there a way where the end date column marks by his own every time i mark the complete check box on rorws. I will like to know is there a way to do that. thanks
-
Feature Request: Ability to Modify the Working Days of Specific Line Items
While building out a Gantt or waterfall chart in Smartsheet, it is not uncommon to have some tasks that can only occur during a weekday while others can occur on weekends. It would be great if one could modify the working days at a more granular level, that is the ability to edit the working day property of each line item…
-
Schedule Duration Issues
I've been working in a CPM schedule. The original showed a 141 day duration, starting 12/12 and ending 05/04. I'm updating some of the relationships as I had to rearrange the work pattern a bit, now my schedule shows 144 days, starting 12/12 and ending 6/29. Does anyone have an answer as to how I gained only 3 days…
-
Personalized user authorization for one cell, and date recording
Hi all, I have a couple questions for all the Smartsheet pros out there! I'm working on a sheet and I would like my team members to be able to update its content. The first problem is that I would like them to be able to edit only some columns and rows, depending on their responsabilities in the project. I mean that each…
-
avoid the shared person delete my row
hi, i see some potential of lose of my data if shared to others. for example, my project schedule shared to partnes and they have to update the status, since they are editor and they can delete my row accidently, how could i avoid from this issue to be repeated?
-
Report Builder Gantt Chart is off
I've been playing around with report builder, to create a summary page of all my sheets. I have a check box I use to filter the lines I want on the report, which are typically the first/top line, which is the entire project. The Gantt view in each sheet is correct, but in the report, every line has the gannt shifted by one…
