-
Automation
I have a sheet which has all of the training details of people who work for us. Previously I have set an action every week to email people whose certificates have expired to remind them to send me their new certificates. I want to use the new automation function to do this for me, however I can't see how to trigger it...?!…
-
Sum of Values in Another Sheet, Using Collect
I would like to find the sum of the enrollments in a particular course from one sheet (Sheet 1), and display in another sheet (Sheet 2). Sheet 1 There are three columns, Course, Students, Term. Course | Students | Term BUS 101 | 12 | Summer BUS 101 | 33 | Summer BUS 101 | 15 | Fall ACT 223 | 16 | Fall CAR 322 | 4 | Fall…
-
Formula to auto populate a number based off cell input
I'm looking to see if there's a formula or other means to have Smartsheet auto populate a quote number and duplicate that number if the same name is added later on. I am working on building a quotes log where we input a project name in Job Name which then auto fills to the Job Name Master. Next to the Job Name Master…
-
Google Sheet Sync into Smartsheet
I realize Smartsheet allows sync for Google form; however, does it allow sync for Google sheet and vice versa?
-
Count Children in adjacent column
How do you write a formula to count certain values of an adjacent column from where you want to the count value displayed. In my sheet I need to count open positions and filled positions based on the status. My sheet is very large so I have to replicate this many times with varying row #s so looking for a quick way to tell…
-
Admin Access to Everything?
Is there a way that a Smartsheet Administrator would be able to gain access to all sheets/workspaces, even if not specifically shared to the admin? I am asking in terms of access controls, so we can put a control in place where the admin ensures no PI or Confidential informaiton is being added. Thanks!
-
At-Risk Flag
Good Day All, I am wondering if there is a way to apply this format to my sheet. I want to be able to move a task to the executive dashboard automatically/ real time. For example, I want to be able to mark a task as at-risk and the task will move to the project dashboard automatically. I am still completely new at…
-
Data from one sheet form to populate another
I have created a smartsheet that contains a form for my team to fill out. Once this form is filled out I would like that data to go to the main sheet that is viewable by my team and then populate another sheet that is viewable to the managers only. Is there a way to have that data when added to sheet one (main sheet) via…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Drop Down List Selections
Can I build a drop down list that allows multiple choices to be selected?
