Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
Is there a way to define a picklist with values and then leverage that sinle picklist on more than one sheet?
Has anyone created a Smartsheet template that follows the ADDIE (Analysis, Design, Development, Implementation, Evaluation) model of instructional design? I'm looking to use Smartsheet to manage our ID process, which is based on that model. Thanks!
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
Hi Could someone help please? I'd like to set a formula in a sheet with say 3 columns. It needs to sum/count depending on the answer of the first two columns but not them both. If either of the columms say "Yes" then that is good enough to be counted in the 3rd column. For example: Column A: Yes Column B: Yes Total: 1…
Hello, I am new to Smartsheet and agile and am looking for best practices. If you plan a task for the sprint and it suddenly is stopped or placed on hold, what is the proper way to record this? Should you simply delete the task from that week's sprint? Perhaps add a status called "Dead/On Hold"? When it's outside of your…
Is there a feature to have sheets automatically save? My group and I have found it very troublesome and inconvenient when we lose valuable work due to the browser closing or changing tabs on active sheets. It's nice that the sheet notifies us that we have not saved, but sometimes that could be overlooked if you're moving…
I am trying to get a sheet to link into another however we want to be able to use the sheet over and over again and have it where it will link in new rows. Is there a way to do this? Please Help Thanks
All, I'm hoping someone can suggest a solution. I am trying to reduce the amount of time spent re-entering data about upcoming bids from one spreadsheet to another. My company has a master list of bids over the fiscal year and every week my boss produces a separate sheet of just the upcoming bids that he can then use…
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…