-
Removing contacts
We have a situation where in multiple sheets we have columns that are assigned to contacts. When a contact leaves we remove them from the licensed / unlicensed users and also from the My Smartsheet Contacts lists. However, in sheets where that contact has been assigned a task in the past, when you start to type a name…
-
Work Insights
When I filter my work insight charts to not include Blanks it is only filtering out some of the values. My filter is ("column Does Not Contain "") Does anyone know how to make it pickup all blank values? Thanks,
-
Populating 1 Cell from Multiple Cells within the Same Row
I'm trying to have a formula populate 1 cell, based on the responses in 6 columns in that same row. If any of the 6 columns are blank OR have "No Scope", nothing should be displayed in the "Scopes" column for that particular scope. Otherwise, if there is text in any of those columns in that row, the "Scopes" column should…
-
Smartsheet report cell linking not working
Hello, I am trying to edit a Smartsheet report to update a dashboard and cannot get the content to populate. I linked the correct cells into a summary sheet called Portfolio and the data is populating correctly. But when I go to pull in a specific column data from Portfolio to the report sheet called Report, the column…
-
Don't group friendly reminders
Hi, When a user has 3 requests that are over due , the user now receives one mail with all 3 lines in the mail. Also with a link to the sheet, but when the user tries to open this link he receives the message to request access to this sheet. what I want is that with a reminder the user receives the same mail as originally…
-
Dashboard chart from a report
I have a report which collects data from multiple sheets - this includes project health using RYG status. I would like to add a pie chart to reflect project health on the dashboard using the collected data on the report and it's giving me "The selected columns cannot be charted". Is there a way around this?
-
Parent worksheet shared automation notification
Hi, our organization would like a notification to power users if the entire workspace is shared by mistake. How can we do this given the Automation inside 1 specific sheet only addresses that sheet sharing?
-
Conditional formatting based on column date
Hello, I am trying to change the status of an action item to Red or Green based on the date it was completed. The logic in my head, reads as follows (if (Completed>EndDate)) -> RED, else Green but when using condition formatting , its not allowing me to select the EndDate column, instead its asking me to put a specific…
-
Moved rows not appearing on selected sheet
I have a saved workflow that triggers when rows are added or changed and when 'Done' is checked, that selected row is to move to another sheet. For some reason the rows have disappeared and not appear on the selected smartsheet. Can someone help with this? Thanks in advance.
-
Sort in sheets
Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
