Community Platform
Discussion List
-
Changing a cell's values from code in a different cellIn Formulas and FunctionsIs 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([email protected]=X, different_cell=XX, different_cell=XXX)
-
Formula to count of items in a multi dropdown listIn Formulas and FunctionsHi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use …
-
Outlook Integration not installingIn Using SmartsheetInside 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&…
-
Warning message when Duplicate entry is done through formIn Formulas and FunctionsIs there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.Answered - Pending Review 1.2K views 17 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Can Formulas Reference Reports?In Formulas and FunctionsI'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.…
-
Delete and Lock rowIn API & DevelopersDear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Remove Primary Column From ReportIn Using SmartsheetI am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
-
Community BadgesIn Using SmartsheetHi 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 .…
-
Filter View Access for certain usersIn Using SmartsheetHi 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 specificatio…
-
Add Actual start and completion date based on status columnIn Formulas and FunctionsAll, I want to fill date column based on status column. 1) If status is "In Progress" "Actual Date" is filled by today's date. 2) If status is "Completed" then "Completion date" is filled by t…
