-
Harvey Balls Automation
I am trying to put together a formula to automatically change the RYG harvey balls based on the end date(due date) and the completion status of the empty/quarter/half/three quater/full harvey balls? I was hoping to get some help putting the nested if statement together. Here are the conditions I am working with and a…
-
Dependencies for drop-down menus
Hello, How can I create a drop down menu dependent on value selected on the previous drop-down menu? Thanks Laura
-
Automated Checkbox column
Hello - 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
-
If / and formula
I am having a slow day, brain wise today. I need to have a formula for a RYG column, that looks at two check box columns. First checkbox will change the RYG ball from Red when not checked to Yellow when checked. Then i have a second check box column for another department to change the SAME RYG ball column to GREEN when…
-
Listing Options in IF formula
I'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 automate the position title for each payee. Here's what I've got to work for one position…
-
Trying to calculate dates
I'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?
-
Formula help
Hi, I am trying to extend a formula to look at a second Criterion in a spreadsheet. the current formula is ="NSW (" + COUNTIF(CHILDREN(State6:State61), "NSW") + "), QLD (" + COUNTIF(CHILDREN(State6:State61), "QLD") + "), NT (" + COUNTIF(CHILDREN(State6:State61), "NT") + "), WA (" + COUNTIF(CHILDREN(State6:State61), "WA") +…
-
Return cell value generated by SUM formula as a number
Is there a way to return the numerical value of a cell that contains a formula that is counting the number of checked boxes in its children cells? My current formula in the cell is: ="Complete: " + SUM(COUNTIF(CHILDREN(), 1) + COUNTIF(CHILDREN(Complete96), 1)) in order to count the number of checked boxes in all children…
-
Text indicator when pasting values
I have a 10 digit "Store #". We use the right 5 digits as a "Site ID". I did a "Right" function to grab the 5 right digits. My Index/Match formula returned a #No Match error. So I copied & pasted values to get rid of the formula. Index/Match still did not work. I found a hidden leading apostrophe (like Excel when you want…
-
sumif formula
=SUMIF(Date past due: Date past due,>TODAY(), Amount:Amount) #unparsable The amount is coming from a vlookup from another smartsheet The past due date is a formula with in the same sheet
