Formulas and Functions
Archives for September 2018
Discussion List
-
Countif formula... using crosssheet formulaIn Formulas and FunctionsI've tried both... they don't work they say unparseable... what am i missing I want to I am looking to add up all P1's that have a region of America Break Fix and a status that is not finished or cancelled, then count all the P1's in the…
-
Auto changing status based on due dateIn Formulas and FunctionsHi, i am hoping this is possible and someone can help? We have created a sheet which is populated from a form and is working really well. We populate the "Required completion date" base on the type of issue and this is automated…
-
Using decision symbols to change textIn Formulas and FunctionsPlease can somebody help me, I'm new to formulas! I'm trying to get text in a cell to change depending on what decision symbol has bee selected (YES, NO, HOLD) I managed to get it working with just 'YES' as follows: =IF(Graphic6 = "…
-
Hybrid Report/SheetIn Formulas and FunctionsI'd like to use Smartsheet to track performance on a multitude of projects. I can use a Report to quickly gather a list of assignments and compare Need Date to Date Completed. But I can't add any additional columns (i.e. with formulas t…
-
Join and Collect Function with HyperlinksIn Formulas and FunctionsHello All, I got my function to work the way I wanted it to, but it did not keep the hyperlinks when it gave me the values. Is there a way to keep the hyperlinks or add them back when using Join(Collect())? =JOIN(COLLECT({Sandbox - DR - …
-
Auto filling a cell based on the entry in another cellIn Formulas and FunctionsHi, We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name? I dont want this on the form just on my sheet when the entry has be…
-
Listing Options in IF formulaIn Formulas and FunctionsI've looked at the forums and tried as many variations in the formula as I can think of, so I need some help. My two columns (both drop downs): Payee Name Payee Position *(location of formula) I'm trying to get Payee Position to autom…
-
Automated Checkbox columnIn Formulas and FunctionsHello - I am trying to make my checkbox column automated so that when the PARENT rows is checked all the CHILD rows get checked. I can only find help on the reverse. Can someone help me write that formula? Thank you Erin
-
SUMIF statement based on datesIn Formulas and FunctionsI would like to create a SUMIF equation to only sum data (column F) based on a date range (column B). It works in excel with the following equation for reference. =SUMIF($B$9:$B$2000, ">=9/1/2018", $F$9:$F$2000)-SUMIF($B$9:$…
-
Trying to calculate datesIn Formulas and FunctionsI'm trying to have smart sheets calculate a new date. I'm using =[EndDate]5+1 but it's not returning a date. What am I missing?