I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbo…
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the defaul…
I need to get the "Length of Day" that is set in Settings so that I can perform some time calculations on the Length of the Day set for the project. Is there a way to derive this?
Greetings - I'm having an issue trying to flag duplicates from 2 separate columns in the same sheet. I have been able to flag duplicates in a single stand-alone column but trying to using the same for…
Hi, I have assigned multiple tasks to Jane, but I a new person is now taking over all of Jane's tasks. So is there a way I can bulk assign all the tasks and the sheets to the new person? Thank you!
I have a Smartsheets survey form that gets automatically sent out in a link via email when JIRA tickets in a specific project are closed. Our JIRA admin folks setup that automation, as we do not have …
I have a dashboard I saved as a Template - when someone saves as new and uses that template as soon as they edit the widgets the formatting is lost. Is there a way to maintain the dashboard formatting…
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions …
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Curren…
How do I hide a row, is there a specific from or sheet template that allows for hiding rows? I do see that hiding colums is possible, looking for the same functionality but for an individual row.
