Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Parent/Child Columns
Would anyone else find it useful to be able to assign a status of child to a selected number of consecutive columns adjacent to the designated parent? For me this would be useful in quickly hiding and unhiding child columns, and for including child sums in the parent, and for making sure that any new columns so added would…
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
Resource View: % allocated bar
Hey team. When I look at my resource view, both within the project, as well as in the Resource View area, the colored bar is not over Mon-Fri, but over Tues-Sat. I have already changed my account settings to show that our work days are M-F. Ideas?
How to automate the predecessor?
Is there a way to automate the predecessor column? I don't want to manually enter each number.
Using reports in Sights Metric Widget
Hi, Is there way we can use Reports within a the Metric Widget in Sights? I have a set up where I am trying to display "Counselor of the Day" in this widget, but my only option is to use the sheet as a source. When I do this, the link to the source cell is static and It only points to the cell that was initially selected.…
How to combine different data from several sheets into word processor document?
How do you combine different types of data (different column headings) from several sheets into a single word processor document? I looked at the Google doc mailmerge, but it will only merge the data from a single sheet. I looked at reports but the mailmerge does not work with reports. I looked at linking the data to a…
Assigning contact to multiple tasks
Is it possible to assign a contact to more than one task at the same time? I have a sheet with 65 rows - there are contacts with multple tasks so trying to avoid having to pick from the list on each single task. Thanks in advance for any help offered.
Clear Cells if Time Is
Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be…
Owner Task Counting and Reporting
How would I create a formula to calculate tasks complete (last 30,60,90 days), open, past due by owner similar to this screen shot which comes from the Webinar - "Manage and Track Tickets with Custom App".
Formula Imbalance
I know I've missed something basic here. =SUM([Contract Amt]1:[S- AWO $]1:[CL AWO $]1)-([Material Allowance]1:[Sub Allowance]1)/[Total FB Hours]) Thanks for help!!
