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
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.
Rookie Help with Due Date and Overdue
I have a start date column, due date column, completed date and would like to have overdue flag column. How to set formula that if due date passes, no completed date and have flag come up in overdue column?
Consolidate time sheets
Hi relative newbie here... looking for help. I would like to set up time sheets for individual team members is a design studio. They will list jobs worked on by job number to allocate time worked on daily. I would then like to consolidate all the data into one master sheet and run a SUM IF formula to calculate the total…
Freezing rows & minimize/maximize feature in sights
Dear smartsheet team, the freezing of rows would be more than helpful! I am working with Smartsheet on various customer projects and a have a great demand for this feature! Is there a status on how this goes? I think its a frequently asked question... Also regarding smartsheet sights, it would be great to add a feature…
Gantt chart - month/year in one row
Hi, We have quite a long project happening. We would like to know if it's possible to show the Gantt chart view with weeks for 2017 and quarters or years for 2018/19. Is there anyway of doing this? Hope this makes sense!
Lookup formula
HI, Everyone, First time to ask, thanks for helping me. I have a task that need to build summary report for strata managers. They need to know when to attend different client meeting. At the right hand side of picture, there are columns for strata , strata manager, month. E.g., BCS1236, Column Jan, you wil see Jan 17, 2017…
regarding Auto Calculate Today date
Hi I Am Trying to set a Notification on a Collection sheet that i track Collection notes and Promised date when the customer Promised to pay now i have a date column which i type the date we need to call back the customer but is their a way to make auto Notifications any date that is past "today " Meaning to say if i set…
Alert Owner When New Action Is Assigned
Trying to figure ouut how to alert the Owner when he/she is assigned a new Action Item on the SmartSheet. (Owner is a column linked to users). Want to avoid everyone (45+ users) getting an alert everytime an owner get a new assignment -- just the specific owner. Thanks!
Sight Cell Linking
I want everything that is under a Parent Row on a Sheet to show on our Dashboard. Is it possible to cell link ALL children under a parent row to a Sight/Dashboard? Examples: If any rows are added they will be included If only one row is populated, only one row will show in Sights
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…
