-
Join us for the Jumpstart 2026 Festival with Community!
Four years ago, we threw a virtual party to kick off the new year and bring this beautiful Community together. Because of you, we've grown from that one event to a week. Long. Festival! 📢 You read that right: A week of celebration. Two massive events. Starting the week of February 9, the Community will be a place of…
-
Date Based Automation Not Working
We have a sheet to help track when notary renewals are upcoming for staff and its a fairly simple process. We have a date column that lists the expiration date, a helper column that turns that into a total day count, status, and if an application was recvied. The trigger for this would be when that Days Until Expiration…
-
Current User Chart from Metric Sheet Data
I am trying to create Current User Charts for a Dashboard. I know these charts are typically made by creating a report. However, I am dealing with more data then the report will support filtering. Currently, I have 4 sheets with a total of 54K rows (total across the 4 sheets). So I thought about creating a Metric Sheet and…
-
SUMIFS/VALUE
Hello, On sheet A, I have 2 columns (among many others) . Column1 contains a LEFT-formula that returns 3 digits. Column2 contains a LEFT-formula that returns 3 digits plus a hyphen and then 2 more digits. On sheet B I have a SUMIFS formula that references sheet A. If I reference column2, it works. If I reference Column1 it…
-
Deleting Columns
I have a sheet (I"ll call it Sheet 2) that is populated with an automation of rows copying over from another sheet (I'll call this Sheet 1). I only want to see 5 of about 30 of the columns in Sheet 2. If I delete columns on Sheet 2, when a line copies over from Sheet 1, the next day, all of the columns reappear on Sheet 2.…
-
Cannot see sheets shared to me
I can no longer see all the sheets shared to me, even though I could see them all last week. I have requested access to them again and was granted 'edit' access and used them the same day. But the next day they have gone again. I have tried logging in with a different browser but still cannot see the sheets. Why is this…
-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…
-
What is the best way to create a form, where you want to capture info on multiple occasions?
We are creating a three part learning series for HCP's and want to use one form to capture information presented during each visit. Is it possible to use a logical sequence only shows once each visit is entered? (Ex. Date 1, xyz presentation, then Date 2 is available to populate to enter xyz presentation) Or would I need…
-
Need help with date reporting formula
I have 4 formulas in seperate cells that look at open and closed actions and does a count of how many there are for those months. The current formula for the current month:- =COUNTIFS({Date opened}, >=DATE(YEAR(TODAY()), MONTH(TODAY()), 1), {Date opened}, <DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)) works fine and has done…
-
Resource Calendar - OOO
Hello Smartsheet Community, Is there a feature to create a calendar that would list when project resources are out of the office? I have an Excel document, but wondered if there is something available. Very helpful when looking at the months ahead for timeline.