-
Centrally managed column values? Multi-project rollup?
I'm a SmartSheet noob investigating whether it's possible to recreate in SmartSheet what we've done in Airtable. I'm pretty sure SmartSheet can do what we need, I'm just unclear on how to adapt the flexibility of Airtable to fit SmartSheet's more typical enterprise app structure. Questions: Does SmartSheet have a concept…
-
Help with template set selection
I'm looking for a template set (set of template sets!) to create a prototype but I can't find what I need. Could someone give me some recommendations? We will have multiple templates for different types of project (website development, etc.) and for personal task/objective management. Some of the project sheets need to…
-
Does anyone have a project plan for installing a new phone system?
I'm trying to find a project plan for implementation of a new phone system. I know every system and every company will vary but something to start with would be so helpful to me. Thank you
-
Formula cross referencing sheet via template
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status…
-
Ever invented or thought about how to use Smartsheet for the holiday season?
Hi, Im curious about what the community has built or dreamt of building for holiday season needs? templates for sending /automating holiday cards? gift list and shopping? menu/party planning? santa list etc? Im interested in ideas to spread some help and joy via smartsheet this pending season.
-
Have a specific cell auto increment up as a new number is added
Per the example below, column "Total UG Footage Complete", I would like have the cell with "50" in it auto increment up when the box is highlighted and I added another 50 for it to show 100. Can that be done?
-
Project Tracking and Roll up
I have used this already for my overall project tracking and the dashboard. I tried to use template for another Project by saving as new the template set. Why is the set showing me a copy of the previous template set and not updating with my current project plan?
-
WorkApps
Tried experimenting with WorkApps this weekend and I am super excited about it, but I do have quite a few questions and blockers at this point, who can I work with to try and get answers or resolution of the issues? I don't want to keep pasting them into new, individual messages and cluttering the community. But I do have…
-
Automate RYG For Project Tasks
Hi All i am very new to SmartSheet. I am working on the project template which can help to highlight some tasks that have been overdue with RYG. Need your kindly help on the formula... 1. If task status is complete: Green 2. If the task status is Not Started: 1. Scheduled End Date is behind today: Grey. 2. Scheduled End…
-
Can I remove the "initiative" level in the OKR template set with out breaking any built in formulas?
I am wanting to use the OKR template for tracking my individual Objectives and Key results. I find the added "initiative" layer in the Objective worksheet to be unnecessary and distracting. If I outdent my KRs and delete the initiative level- will the template set still function as intended?
