-
Cross Referencing Data Across Sheets
I've read several threads on this and tried to figure out solutions but am still stumped. I am creating a workspace for managing events. I have vendor lists with their rates and a planning sheet with the number of staff we need and which activities will be booked, etc. I'm trying to create an expense sheet where I can have…
-
Keyboard shortcut indent after CTRL+K went away
Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyboard ( ] = AltGr 9) Ctrl AltGr 9 just types the symbol ]. Anyone else struggling with…
-
Embedding LinkedIn Learning content
It would be great to have the LinkedIn Learning domain on the approved list to be able to embed any of their web content into Dashboards. We utilize that a lot throughout our company for certifications, growth and development, diversity training, etc. Their videos would make great content for our Learning and Development…
-
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…