Formulas and Functions
Archives for August 2019
Discussion List
-
Server/Local sheets get out of sync, some permanentlyIn Formulas and FunctionsHi all, I am working with SS support but I thought I would reach out here as well According to T2 support ...If our server has not processed all data/ formulas before a save is made the sheet may show a different version than our server…
-
Formula is not copyingIn Formulas and FunctionsHi, I am having a problem with one formula that is not automatically copying to a new row (there are others that are being copied). The formula is: =JOIN(CHILDREN([Column Name]1, ", ") Why every other formula is being copied bu…
-
Master Sheet - Exceeds Row LimitIn Formulas and FunctionsI am struggling to figure out how to have a "master" listing of customers that can be referenced by various sheets via INDEX/MATCH cross sheet formulas when that list is too large. Here is my background: I have a master custome…
-
Locking Cell - with ConditionsIn Formulas and FunctionsIs there any way to lock/restrict a cell that asks users to choose a date? For example, I want users to be able to choose a date earlier than what is "listed" in the cell but be unable to choose a date after the date that is lis…
-
Index, Match with Find and Left functionIn Formulas and FunctionsI am trying to get a formula to look up a value with the INDEX / MATCH function and the Search_Value being the numbers up to a "-" dash from the "Type For List" column. The index/match does not seem to like the LEFT or…
-
Formula to change textIn Formulas and FunctionsHello, How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say immediate, and if it is withi…
-
=ROUND(SUMIFIn Formulas and FunctionsHi =ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0) The above is my formula. It says, "IF the value in the Pareto Category column is the same as the value in th…
-
Deleting one outgoing cross-sheet reference ended in ALL references from the same sheet being deleteIn Formulas and FunctionsHello, I spoke to Support on the phone yesterday but we haven't had a definitive answer on what the expected behaviour for this scenario is. I'm curious to see what other users have experienced. In the the "Edit or Remove links&qu…
-
Formula that averages a columnIn Formulas and FunctionsHI Smartsheet community, I need a formula that averages one column (# of jobs) if a checkbox is checked. I think I need to use AVERAGEIF and ISBOOLEAN, but I can't get the syntax right. Help! -Bridget Sloane
-
Mandatory Fields on SmartsheetsIn Formulas and FunctionsHi, Is there any way to make the category field and the risk level field mandatory for users to complete before they can change the status from open to closed in my Smartsheet? Currently we have users who are just closing the status witho…