As the summary of all Project information, is it possible to pull the start date from a particular project folder; noting there are many?
You'd need to connect the sheet with cross-sheet formulas, or you could use cell linking.
Another option that automates it completely is the Premium App, Control Center. Is that an option?
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I would need cross sheet references as I have many projects, and this project folders. How is this updated as new project (folders) are added?
You'd need to add the additional project's cross-sheet references manually.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi, I am wanting to display multiple vlookup results from a separate sheet into 1 cell. Example: Cabling Allocation Sheet, where we input an allocation to a text name "ECC" which can be multiple cables in the same run. Requirements Sheet - Need the output to be "115, 116, 117" (I have manually written them in at the…
I am reaching out to seek your assistance regarding an issue I'm encountering while calculating the number of surveys completed on each day of the week (Monday-Sunday). Despite various attempts to identify the correct day of the week using functions like DAY, WEEKDAY, and DATEONLY, I am consistently facing discrepancies…
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
©2024. All Rights Reserved Smartsheet Inc.