-
Import Hyperlinks via Formula (not via Cell Linking)
Hello, Hyperlinks do not import when I use a formula (e.g. INDEX/MATCH, or INDEX/COLLECT) to locate & import a targeted cell. The text in the indexed cell is imported, but not the hyperlink. I am aware of Cell Linking, which does import the hyperlink. But it is burdensome to apply Cell Linking to all the cells in my sheet.…
-
Automatic Time Tracker in Smartsheet?
Is there a way to automatically track time in smartsheet. For this example each row on a sheet is a job. I'd like to have a checkbox to have the job start, and a checkbox when the job is complete. To complicate matters, I'd also like the ability for the user to pause the job and restart the job. I am envisioning a "job…
-
Merged: Conditional Drop Down List Values
This discussion has been merged.
-
Allow auto scrolling with middle button mouse click
Allowing using the middle button on the mouse to start an auto scroll on the grid view. Some of the sheets are quite wide, and it would be nice to not have to use the scroll bar at the bottom to move left/right.
-
Data mesh cell history
Hello! I would like to make a suggestion regarding cells that are populated via Data mesh. As of right now, when a cells gets populated via Data mesh and you click on View Cell History, you can see the name of the person who owns the Data mesh. However, you have no idea if the person manually input that information or if…
-
changing the Row number for coommets?
Hello, Is there a way to change the comments notification to show a Ticket ID number instead of the row number? So in the picture change the Row 441 to ticket ID 500?
-
Question: Hide/Unhide columns
Hello Smartsheet Gov community! I have been a Smartsheet user for many years and exclusively in Smartsheet Gov for 2.5 years now. Today one of our users shared that a free collaborator had unhid columns in a sheet. I shared with her this wouldn't be possible since only licensed users can hide/unhide columns (even with…
-
IF function to return value based on dates
I am trying to get a value when I put in a particular date If a person puts a date in the Target completion field, I want to return a Sprint in the Sprint field. I dont know if I can use the month or does it have to be between? For example =IF([Target Completion Date]@row) is between 8/1/2024 and 8/31/2024 then return…
-
Sending a single email to multiple people
Hi, I have several automations set up to email coworkers. However, usually I need everyone to be literally on the same email. I understand that ultimately smartsheets wants/thinks people are going into smartsheets to "work" but sometimes that's not the case, sometimes you have people outside your organization or whathave…
-
I want to count items within current month without needing to change the month manually
I need to report on the number of items that appear in the current month to date. Is there a formula that can be applied without necessitating manual entry of changing the month manually?
