-
Help with IF AND formula with cross sheet reference
I am trying to write a cross sheet formula, and I keep getting an #INVALID OPERATION error, and I cannot puzzle it out. My current formula: =IF(AND({Scenario REQ ID} = [REQ ID]@row, {Scenario Status} = "Pass"), 1, 0) If the REQ ID from my scenario sheet matches the REQ ID of this row, AND the Status on the scenario sheet…
-
Adding a New Sheet to an Existing Summary Report
Hi there, I have a workspace tracking our grant applications using the Multiple Projects template. Each grant has it's own sheet for tracking the application process, implementation and reporting. The "Report - At Risk" and "Report - In Progress" reports are only pulling data from the original sheet I created. I've tried…
-
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.…
-
Editable Font Size and Colour for Data Labels on Charts
It would be helpful to have some control over the size and colour of data labels for charts. e.g. if your dashboard font sizing is consistently a smaller or larger size than the default for data labels, it looks untidy, often data labels appear too large on a chart as a result of the large default font size too.
-
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…
