-
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…
-
Why is the content of a cell clearing when the cell is clicked on?
I have a colleague that has been experiencing an issue for the last 9 months with his sheets. Every time he clicks on a cell with content already in it, the cell clears. We've tried restarting, looking into issues with using a mouse, but nothing seems to fix the issue. We have a very inconvenient workaround of hitting the…
-
how to sort alphabet in sheet
I want to reorganize my row to be alphabetically order. Does anyone know how to do that?
-
Development Environment for Production Change Development
Hi all, I have a solution that I've pushed out to production but now there are changes being asked for. I've duplicated my workspace as a way to build out and test changes safely. As I'm beginning to work thru solving the changes in this duplicate/dev environment I'm seeing the amount of time and potential for error it…
-
I want to send automated email to "assigned to", from a sheet, but only one reminder email vs mutlip
I have title, "assigned to" column, status(task 1), due date (task 1) columns, status(task 2), due date(task 2)…it goes for at least 10 tasks. The conditions to trigger the emails are, trigger 2 days before due date(when status is not equal to completed) and leave weekends trigger on due date(when status is not equal to…