-
Bring Back The Old Sheet Picker for Copy/Move Row Automations
The new "search based" functionality for picking the destination for copy and move row automations has proven to be more painful than helpful. I wish I had screenshots of the old one, but it was much more user friendly. I'm putting this out there to hopefully get the new UI reverted back to the previous UI. 🤞
-
Only 1 sheet
I have only 1 sheet in my account, but it's now only read-only, saying I have to upgrade. What changed?
-
In Calendar and Card Edit View, Hide Data in Hidden Columns
Currently in Calendar and Card view, all data from all columns is visible when you double click on a line item. It would be great if data in hidden columns was not shown in the Card or Calendar edit view, or if there was a way to select what was visible in the edit view.
-
Linked Cells Don't Match
Hello! I am attempting to link cells (Duration, Start, Finish) from a project's sheet to a master sheet. However, once I link the cells, the Finish date is different on the master sheet than what has been entered in the project's sheet. Cells in project sheet: Cells in master sheet: The Finish date should be 1/2/23, not…
-
Auto-Logout for Inactivity Setting
It would be great to have the ability to set an auto-logout for inactivity at both the user and account level. Benefits: Enhanced account-level data governance Prevent unintentional unauthorized access on shared devices Ideal function: Sys admin can set this at the account level with these selections Ability to make…
-
Need an equation to count text from a column with multiple selections
I'm having the issue of getting an equation to work properly in order to get a count on text in a drop down list of items. For example: I need to count how many times "Electrical" or "Paint" is mentioned in the same cell for the whole column. I keep getting error messages. The only equation that I could get to work would…
-
Published Assets and Connect User Count - Shared Users
I had a few questions regarding the Connected User, what trigger a user to be counted as a Connected User and the effect of sharing published assets. Is one of the triggers to be included in the connected user count who is shared to an asset regardless if they don't have a Smartsheet login or whether they access or view an…
-
Removing duplicate rows in a sheet
Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the process of removing those duplicate rows.
-
Creating an Automation based on days
I'd like to create an automation to send a notice to a coordinator when days worked are within 2 days of Days allowed to work. I'd also like to add a conditional format that highlights the row. Please help.
-
Is there a way to reference the row above?
I'm trying to mark active child tasks in an overall task. I'd like do =IF(Done@row-1 = 1, 1, 0) in the Active Task column, but we often insert tasks and I don't want to put a hard @row number in there that would need to be maintained when new tasks are added. Same for automatic numbers in a RowID column. I was also doing…
