-
Persistent permalinks
I have an issue where my permalinks become useless after midnight. I create a bunch of permalinks to the rows in my main sheet. At midnight I move all these rows to an "Archive" sheet. Is there a way for the permalinks to reference the row that has been moved? Anyone else have this need? I had thought about renaming the…
-
COUNTIFS with multiple IS NOT statements
Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operation. I can't figure out what I'm missing in the formula. Here's the formula that works:…
-
Email Alerts for Multiple Rows, Individually
Is there a way or setting where I can control how email alerts are sent when multiple rows match the criteria? For a while, even if multiple rows matched the criteria, we would always get individual emails/alerts for each row. (i.e. 6 row match criteria = 6 emails). However, after the recent update, I now only get 1 email…
-
Ranges
Hi, I am using "Ranges" when I use vlookup etc, but I don't know how to completely delete a Range (or multiple Ranges) Does anyone know how to delete all "old" ranges from within smartsheet memory? I think I need to free-up some resources, I keep getting the error message; "You can only reference 25000 cells" "Please…
-
Smartsheet named to Fast Company's Annual List of Most Innovative Companies 2023 ⚡️
Have you heard the news? Smartsheet was just named to Fast Company's annual list of the Most Innovative Companies 2023 in the Enterprise category! We were recognized for creating a unified digital workplace, allowing users to drive meaningful change. They specifically called out DataTable, Brandfolder, and Outfit. 🎉 Read…
-
Upcoming Smartsheet Q&A Webinar including Me!
I'm excited to announce that I was invited to take part in a Smartsheet Q&A webinar, and I will be one of the panelist answering questions! Date: 09-March-2023 Time: 1:00 PM EST (GMT-5) If you are interested, here is the signup link: tinyurl.com/pwsmartsheet
-
Adding a Smartsheet Form to MS Teams
Has anyone discovered a way to just add the actual form from a smartsheet to a tab in a Teams channel? I am looking for a way to have my dept. log and archive certain information that they come across in their day to day work. I felt the best way to do this was by giving them a simple form to copy paste that info into. I…
-
Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…
