-
Drop down Multi select
With this new function will this be implemented on the forms as well. Will be be able to select multiple options in one field? Or is this function just on the actual spread sheet?
-
Hiding Completed tasks
I'm using smartsheet to track projects and their coresponding action items. After tasks are completed, I want to be able hide the rows to make the smartsheet easier to navigate. Is it possible to hide rows? I can't tfind the functionality. Any help would be appreciated.
-
Count dates and return a valve from another sheet
I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days Thank you for any help
-
How to Create A Template Set
I've created several project management files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??
-
Hyperlink from Sheet clickable in Metric Widget on Dashboard
We are having people create a hyperlink in a cell on a sheet to a word document saved on our O365 sharepoint. I want this link to then be available on the dashboard. I currently have the cell linked in the Metric Wizard, but when viewing the dashboard, the link is broken and only the words are there. The users are not able…
-
Struggling with INDEX and MATCH
Hello, I am trying to automate task assignment using the INDEX and MATCH functions. My formula is as: =INDEX({Order Sets Team Contact Roster Assigned To}, MATCH(Role@row, {Order Sets Team Contact Roster Role}, 0)) It seems to work for one role but produces a no match error for the rest of the roles. Please see attached…
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Forms - request comments and attachments but don't display current
Hi - I would like to be able to create a form in which new comments and attachments can be submitted - but previous comments and attachments cannot be viewed - is this possible? thanks
-
Critical Path Indicator
Are there any options in Smartsheet that would allow me to understand in the Grid View if a task is on Critical Path? Is there a Column type? Formula? etc...? or some type of flag beside just the color of the Gantt bar in the Gantt view? We are trying to filter our projects for Critical Path tasks and our only workaround…
-
Count Unique Values
I have a master sheet that is essentially a list of all the schedules we currently have dealing with projects. Each project has its own project number. All i am trying to do is get a number of the projects we have scheduled to compare to the actual number of projects we have in our queue. Now for the tricky part. Some…
