-
Changing a cell's values from code in a different cell
Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF(column@row=X, different_cell=XX, different_cell=XXX)
-
Enhanced Community Search is Now Live!
Hey Smartsheet Community, The Community Team is excited to announce a new and exciting way to search, giving you the confidence to find exactly what you’re looking for when you need it most. We’ve enhanced our search tool so you can now search for relevant and up-to-date Community posts. In addition to these changes, we’ve…
-
Outlook Integration not installing
Inside of Outlook, I have clicked "Store Add-ins", found "Smartsheet for Outlook" and clicked that. I then clicked the blue "Add" button. This then briefly changes to "Adding..." then to "Added". When I go into my Outlook email list, there is no Smartsheet icon. When I go back into "Store Add-ins" and find "Smartsheet for…
-
Can Formulas Reference Reports?
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person. When I go to do that and the formula asks me to reference a sheet, I am only…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
🚨 New Community Category Alert: Product Announcements
Hey Smartsheet Community, Our Community Team is excited to announce the release of our highly anticipated Product Announcements Category! This category includes all things new to the Smartsheet Product... which is a lot as of recently. So keep a close 👁️ out! From feature releases, enhancements to existing offerings,…
-
Community Badges
Hi Shaine, Is there anywhere that I can view a list of badges and what is required to earn them? It would be great if they had tooltip hovers on them so you could see what they were about without having to go elsewhere. Just a thought . Kind regards, Chris McKay
-
How to you unmark an answer as the "best answer"?
I accidently marked a follow-up question as a "best answer" when I meant to give it an "up vote". There doesn't seem to be any way to remove the "best answer" for that response. How can this be done?
-
Prevent Cell Formula from being overwritten
I have a cell formula that will change the status of the parent cell (in this case Materials) to Green, when all of its children are either Green or Gray. However, since the sheet is shared amongst multiple people, it can be overwritten manually when someone changes the status to a different color then the properties of…
-
Filter View Access for certain users
Hi everyone, I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specifications) into Smartsheet, which will automatically send a notification to the supplier, who…
