-
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
-
VLOOKUP data type question
I'm using this vlookup formula to pull back a value from a data sheet. Let's say the value of NUMBER81 is 123456 and when I type in the formula on the desire sheet it returns "No match". When I go to the ACCOUNTS sheet and look at the data there is a value equal to 123456 in Range 1. When I put an apostrophe in front of…
-
Special formula help
Hi, I'm hoping smartsheet community can help me with an automatic formula. We have a column called "Priority Deal" this is a symbol selection of the stars, where we rate a specific land opportunity (empty/one/two/three/four/five) I'd like to create a formula when a specific star is selected, the column "Deadline Date" is…
-
Creating less than today check box
I want to create a formula that has a checkbox that will check if the due date column is between today and 7 days. It works but when i format it to the entire column it checks off every because because it considers that if the due date column is blank it's less than today. My formula is: =IF([Proposed Due Date]@row <…
-
IF and VLOOKUP
Hi Can anyone help me with these two formulas I am trying to do: 1. IF a cell with a checkbox is true, then run this VLOOKUP formula, otherwise 0. 2. IF a cell contains this text, run this VLOOKUP formula, or IF the same cell contains this text2, run this VLOOKUP formula, or IF the same cell contains this text3, run this…
-
Reflecting only Parent Rows (multiple) on Dashboard
For a project release, we're leveraging checkboxes to track completion of validation tasks. I have a dashboard built to reflect progress, however am having trouble finding a way to only choose the multiple Parent Rows/Roll Up data, as it's making me include child data or nothing.. (including all the child row stats will be…
