-
Help! Refrence using =INDEX in a drop-down single select
Hi All, I'm new to Smartsheet, id like to use =INDEX formular reference to reference another sheet cell. when i select a single option in the drop down it will reference that cell.
-
Linking Errors
Hi When I link out from my smartsheet to individual schedules it does not show the link anymore until I refresh and then it crashes. I get this error - see screenshot
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
-
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…