-
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…
-
Multiple Line Entries with one Form Submission
It would be great feature if one form could be used to fill in multiple lines/rows on a sheet. This would be super useful for my team. As of now, form entries can only create singular row entries on sheets.
-
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…