I'm trying to copy a template to use. I have formulas already on the template, however when i put the new numbers in, it doesn't use the formula to add/subtract them. I have to litterly go through and on every sheet I create from either a template or otherwise, I always have to figure out the formulas again. Is there a way…
I am using one of the PM templates while adding in additional columns for actual start dates and actual finish dates. As such, somewhere I have lost the duration formula in that column. Can someone please help me with the formula that would determine the work days for planned start and planned finish minus weekends? Thank…
Hello - I'm pretty new to smartsheet, but I'd like to start setting up our 2021 project portfolio for our team. What is the best place to start? Should I copy the project folder for each project and start populating? Am I required to use the project intake form (doesn't really apply to our process)? Thank you! Amy
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 1.1.2.4 etc. But I want a system where I can have the format 01.00.00.00 and 12.04.09.11 etc; How do I make sure that there…
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…
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…
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
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…
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.
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?
