The goal here is to create a helper column that with a formula will grab the department information from each task row, and then roll that up into the parent phase and project rows. However sometimes there is a department in the parent rows that are not in the task rows. So I need to be able to grab information from not…
We started moving towards using Kanban boards and have set up lanes vertically. But how do we add horizontal lanes to support a true Kanban board? Also add a yes vote to setting WIP limits.
We have several users getting this error when trying to submit a form even though everything is filled out correctly. It seems to happen when using AutoFill to populate fields on the form. Has anyone else experienced this? Thank you
I have a text column that has multiple emails and each email is separated by commas and i am trying to pull those multiple emails to contact list columns (I have allowed multiple contacts per cell ON) and be able to send alerts. However, when I do that it just stays as text, not contacts. Does anybody have any idea how I…
Afternoon, I've a workaround automation that I'm using for a course training registration sheet (linked with forms) to send to specific people once we've reached a certain number of registrations for that course/component, so they're aware of the numbers and to close off the form due to the limit being reached. I've used…
My dashboards using the Metric Widget are not working I get an error message "Source sheet unavailable". This is consistent with my dashboards set up in this way. The error is the same one that was experienced earlier in the year. Is anyone experiencing the same error?…
I have groups where I need to limit the contacts to I would like to track my resources but my "Assignee All Row": It uses: =IF(ISBLANK(JOIN([Assignee Design Architecture]@row:[Assignee Sign-Seal]@row)), "-", JOIN(COLLECT([Assignee Design Architecture]@row:[Assignee Sign-Seal]@row, [Assignee Design…
I am sharing a smart sheet with a business partner and we were working off the free plan at first. When the 30 day trial ended I could no longer edit so we both purchased the pro plan. However, my PC version of the sheet is still view only yet on my mobile app I am able to make changes as per usual. We have tried removing…
Hello, I am trying to connect a form all the way to a dashboard that will give real time updates and require no manual intervention once made. The form is sent to a group of individuals that will eventually have to be separated out into separate units for which they work for. I am thinking of doing an automation that will…
Hi, I have a sheet summary that is calculating the same values over and over for different categories - a total and progress counts for Fred, Wilma, Barney and Betty. What's the optimal way to do this? Should I create all values in a single sheet summary or can I create multiple summaries for the same sheet, each focused…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.