-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Gantt Chart - Duration changing Start/End dates incorrectly
Hello, I am having an issue when in Gantt chart mode. If I have a start date set, and change the duration to be 2 days, the end date is automatically adjusting to be three days from the start date, even though the duration is still correctly listed at 2. This only occurs over weekends and works properly over weekdays so I…
-
Flexibly managing resources for assignment - by logical project groups
a - We manage a constantly evolving list of projects, with each project being managed by 1-3 Smartsheet Users (our PMs), and tasks being assigned to one of the 15-45 resources (people, -vendors, managers in the customer's company (not users). b - The list of contacts is unique to each project c - The 1-3 PMs need to be…
-
Feature Request: Sheet Sharing History
I frequently send sheets internally to request for updates through the "Email Shared Users" option. While I know there's a CC me option, I think it would be more efficient if I could find a log in the sheet of when users were emailed rather than digging through my own pool of emails.
-
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…