-
Card View - Hide Blanks?
I have a very large sheet with many columns created from multiple specific forms with logic. As such, many of these columns will be blank if they do not apply to the specific project. Is there a way to disable or hide the blank columns when viewing in card view, so the team members do not have to scroll to look for…
-
If they can't share = they can't delete rows and comments!
Having better user control over what users can or can't delete in rows and comments is crucial. I suggest that the current user levels be updated as below "Editor Can't Share" should be "Editor Can't Share or Delete" (If they can't share, they also shouldn't have access to Delete rows or Comments). "Editor Can Share"…
-
SCC Blueprint - Customize Profile Data
Hello Smartsheet Community, I am working on creating a Blueprint in Smartsheet's Control Center. Would someone be able to help me understand the differences between the "Cell Link", "One Time Write", and "Editable Value" options when on the customizing profile data page in my Blueprint settings? I haven't been able to find…
-
How to split the content of one cell into separate columns
I have a cell with data in this format: Approved,AAD:tammy.couch@transcoretech.com , 9/3/2019 11:06:50 AM I already have a formula for the Status Column, which is Approved. That formula is =IFERROR(LEFT([MFG Approval (archived)]@row, FIND(",", [MFG Approval (archived)]@row) - 1), ""). It works great. However, I need to…
-
Symbol Flexibility - more symbol colors
The ability to build our own Symbol Sets for a drop-down menu (even just using the pre-existing individual symbols, not creating a custom symbol itself) is a desirable asset and would assist in various data management senarios that require the use of more than four or five categories of classification
-
How do I change the columns I can "view by" in card view?
I am trying to sort in card view based on the employee(s) assigned to a task. I have a contact list column with this information in GridView. The "view by" feature shows a ton of columns that aren't relevant to how i want to sort but I can't figure out how to switch them out for more columns that are more relevant to my…
-
SUMIFS with sheet reference
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.
-
Grid Calendar View: allow font formatting, specifically color and size
Currently the font size is fixed. Suggest ability to allow the font size to carry over from the grid view
-
Freezing Dates
I am looking to have a blank cell populate a date in a column using an if statement to check for specific values in another column. With excel I would normally use a circular reference to check if(and()) the cell was blank and that the values I want are in another column, and then populate a today(). With Smartsheet it…
-
Resource Management Implementation
Hi everyone, We have recently implemented RM along with Smartsheet Control Center. I think we ignored RM during UAT. And now we are having issues in RM with regards to allocation, capacity & analytics. Will anyone be able to share their implementation strategy with me which may help us. Looking forward to hearing back.…