-
Copy Sheet Summary Field on a Sheet
The ability to copy an existing sheet summary field and edit to save with modified formula.
-
Copying a cell with an auto number from one sheet to another overwrites existing auto numbers
Hello, I'm using two intake sheets for different project types. Each intake sheet is populated by an idea submission form and the entries receive a unique number with an Auto Number column. So far so good. Situations come up where a project of type A needs to be moved to type B. We do this with a checkbox, which when…
-
Can you uses forms to populate fields in existing rows instead of creating an entirely new row?
Hi all, hope this message finds you well. I'm building a sheet with the purpose of being a 'One stop shop' between our organisation and external parties. So far, I've built a mastersheet with a form for our internal team and two separate sheets with their own forms for the external individuals involved. The aim is for our…
-
Creating a formula for metrics sheet with multi-selection dropdown
Hi all, I am creating a metrics sheet, and am having trouble creating a formula to count how many cells of a specific variable (call it "Zone") has multiple selections. I've already counted the ones where only one zone is selected but, but am missing the counts for those remaining with multiple zones selected (can call…
-
How to create a flag column that identifies a scheduling conflict
I am trying to create a checkbox column that gets checked when the conditions of a formula are met. Essentially, I am trying to flag a row if someone is assigned to that row who already has an assignment for that same date AND if the start and end times overlap. Example: Interpreter= John; Date= 6/1/2025; Start Time= 8:00…
-
Calcs for a multiple conditions
Hi, I want to use this formula: =COUNTIFS({1. Main Tracker Range 1}, "Pending", {1. Main Tracker Range 3}, TODAY(-1)) + COUNTIFS({1. Main Tracker Range 1}, "Confirmed", {1. Main Tracker Range 3}, TODAY(-1)) Which has two different conditions, this worked in the Summary tab. When I am referencing it is not coming out. In…
-
Looking for Template Ideas: Grant Scoring Workflow with Reviewer Restrictions
Hi Smartsheet Community, We’re working on a grant application scoring process and looking for advice on templates or structure that could help streamline our setup. Here’s what we’re working with: Total applications: ~50 Reviewers: 6 in total Each application: Reviewed by only 3 assigned reviewers Scoring: 8 scoring…
-
Having automated backups (such as weekly) the formulas also included
Having automated backups (such as weekly) the formulas also included. It would be so good!
-
Report not pulling data from sheet when workspace is selected.
Hi everyone, I have a report that isn't pulling a sheet when the workspace is selected, but will pull it when only the sheet or the sheet's folder is selected. When I select the workspace I can navigate through and see that the sheet is checked off but it won't include the information. Then, if I deselect everything else…
-
Importing Excel Sheet to Update Existing Smartsheet
Hello, I am trying to be able to create an Excel spreadsheet with corresponding header fields. For example, headers in Excel would be "Order #" and in Smartsheet it would also be "Order #" so that whatever is under those header fields would auto-populate into Smartsheet. Whenever I try to import an Excel sheet it creates a…