-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Linking Construction Program line items to relevant task lists
I'm working for a design and construct fit out company and we're looking to invest in control center and I'm just looking at the configuration of the project workspaces and need some ideas for the following scenario.... Each project has a construction programme which is shared with the client. Within that program there are…
-
Merged: Changing Cell Value based on Cell with a Cross-Sheet Formula
This discussion has been merged.
-
Auto generate project number using formula
Hi, I'm trying to create a formula that will auto populate the project number when a new project is created through a form. When a project is added through a form it appears at the top of the sheet. Our project numbering system is YY-XXX where YY is the year of the start date of the project and XXX is the project number…
-
Can you link a field in Summary data from multiple sheets to a report?
I am trying to produce a report of specific Summary data fields, across multiple sheets, and aggregate a list of that particular field. Any ideas on how to do this? In a nutshell, I'm trying to produce a report that will forecast target project delivery dates and I'm currently tracking those target dates in a Summary field…
-
Mass ticking a column, for users who have Dynamic View
Dears, Background : I have a question regarding a Smartsheet tool that I am operating. Essentially, we are using Smartsheet to create, collect and align on data, which then creates reports for the higher level stakeholders. However, since the data is highly confidential, we have to manage access and authority very closely.…
-
How do I enter criteria to return specific results, but not using filters or dynamic view?
I'm curious if anyone has an in-sheet solution for this. I have a lot of data related to store information (store #, address, software versions, regional manager name, etc.). It encompasses all information about a store location and there are over 1800. Is there a way to build a sheet so you can type in the store # and…
-
How can I use one type in cells if the column is another type?
I need to use formulas on the top row and all following should be a checkbox. But when inserting a formula, a Boolean is expected. There a way to get around this somehow? Or can you suggest another way to implement the table?
-
Outbound Links Monitor on sheets
Since there is a set limit to Outbound Links on a sheet (25 millions) and for core sheets that hold information used in multitude of other sheets this number can be reached easily, it would be good (for admins) to have a visibility over the current number of outbound links and start planning/implementing measures to…
-
Possible to use cell linking for formulas?
I have multiple sheets that are set up in the exact same way, used by various team members. Each sheet has several formulas. If there is an update to the formula, I have to go into each sheet and adjust it. Is it possible to have a reference sheet that houses all the formulas and use some kind of link to reference the cell…
