-
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…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
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…