- 让它检查checkbo公式x in another sheet.
Hi all Hope you can help me. i'm trying to make a formular that can help me check off the checkbox in another sheet. So its going to be somekind of formular that looks into another cell and if it is checked off it is going to checkoff in that sheet as well. So 1. sheet is the Intake sheet. - The 2. sheet is the tasklist.…
- Template Set: Marketing Request Management - Standards - Scope of Work cells
I am following the initial setup steps for the Marketing Request Management template set. In Step 2.C. customize the sheets for your project types and team, when I change the cells in the Standards - Scope of Work sheet, it breaks the communication to the Intake Sheet and Form, and gives me an error message "Incorrect…
- Capacity Planning Template
A google search shows me a capacity planning template exists in Smartsheet but I cannot seem to find it among the templates. I can see it via google search but when I go to download it I'm asked to create a Smartsheet account... but I already have one. Can anyone point me to the template within Smartsheet? Thank you
- Template for Scoring Grant Proposals?
Is there a template set that could be used/modified to suit the following need: A team of 4 is scoring grant applications. We're using a form to gather scores for 100 applications (estimated), 4 scorers, 15 scoring categories/domains. I'm trying to set up a metadata sheet to collect everyone's scores. I need a single line…
- Roll over Monthly checklist
I am looking to create a month-end checklist which has list of activities and due dates and tracks the completion status driven by user inputs. What is the best way to a) archive the completed checklist and b) roll over the checklist month over month. The fields are consistent month-over-month with 80% pre-populated in the…
- Cashbook
Hi, We currently use Excel for our Cashbook and there are tons of syncing issues. I was thinking of using Smartsheets but was wondering if anyone has an experience doing this? We have multiple bank accounts that need to have debits and credits accurately input. There are weekly and monthly transfers between accounts and…
- How do I create a template that will save to the workspace where its located?
I have a workspace, lets call it "Awesome Stuff", and in that workspace I have a template called "Template of Awesome Thing". As the admin, when I click "Template of Awesome Thing" I'm prompted to rename it, and then save it in to "Workspaces/Awesome Stuff". When my users click on it, who are currently set as editors…
- Hyperlink Templates
We have the ability to hyperlink smartsheets within other smartsheets. It would help to be able to hyperlink templates within other smartsheets.
- Templates - Hyperlink
I know how to include a hyperlink in a SmartSheet to another SmartSheet. Is there a way to hyperlink a Template in another SmartSheet?
- Adding the template "Team Vacation Planner" to dashboard
Hi, The title says it all. I've started using the SS template called "Team Vacation Planner" and I was wondering how I could add this onto a Dashboard for quick viewing. I tried making it into a report but it only brought the columns; sheet name, created, created by, modified by and modified over. None of the names or…
