-
How to update reports efficiently when column name changes in source sheet?
I have a problem and would love to hear if anyone has a creative solution. I have a large "Master Sheet" that essentially aggregates data from hundreds of other sheets across multiple workspaces and serves as a central data repository. Then, I (and many others) run a lot of different reports off of that "Master Sheet" for…
-
Please advise if you can help me convert this Excel formula to a Smartsheet formula.
I keep getting #UNPARSEABLE when using the following formula: =IF([CUSTODY DATE]7>1/1/2000,IF($MILEAGE$2<=([CUSTODY DATE]7+2),(125+75+40),($MILEAGE$2-([CUSTODY DATE]7+2)*15+(125+75+40)), ) I was told to make this correction, however, I am still having the same trouble: Based on the IF formula provided, $ MILEAGE $ 2 seems…
-
Using COUNTIFS with CONTAINS
Hello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True") The return value that I get is "0," which…
-
Copying formulae on sheets where the input is through the forms function
Hi Smartsheet team, My team and I use smartsheet to track our business development opportunities. When we get new leads our team use forms to input the data they need which then adds a new line into our smartsheet doc. However some of the cells in the sheet use currency formulae which do not replicate when we add in a new…
-
Comparison of two cell with smartsheet
Hi community I'm trying to do something pretty easy but couldn't go further on my own. I have one column where users from one site will answer in every cells "Yes, maybe, no" through a 3 choices list (column Baudouin) that shows symbols (green square ,orange square , red square) depending of the answer And another column…
-
Formula to use to count multiple choice answers in a column by answers
I'm trying to figure out the right formula to use to count multiple choices answers in one column in my sheet. I'm hoping to have this information roll up into a dashboard. But, for the cells that have multiple boxes/answers checked, it is only counting the first answer, not the others. Any suggestions?
-
Manual cell entry/autofill second cell by referencing another sheet
I have sheet 1 with cell A and cell B, I would like to manually enter cell B and have cell A auto populate by searching/referencing sheet 2. best, Owen
-
Raising Flag for at Risk Tasks
I would like the flag to be red if the date is within 7 days of "today", AND, if "Status" is not "Complete", and I want the flag to be white if the "Due Date" is blank, greater than seven days away, or if the task status is "Complete" I have: IF(ISBLANK([Due Date]9), 0, IF([Due Date]9 <= TODAY(7), 1, 0)) I just don't know…
-
Validation Formula
Going crazy. My current formula =IF(AND([Time Missed / Used (In Hours)]1 < 19.99),CONTAINS("Not", [Excused/Not Excused]1:[Excused/Not Excused]1, ".25", "1"))) = #UNPARSEABLE The goal here is to return .25 or 1 into a cell "Totals" if cell "Time Missed / Used (In Hours)]" is less than 19.99 and cell "[Excused/Not Excused]".…
-
vLookup and AVG
Hello, I am trying to do a vlookup to count the average days to fill for each Org Level, by Exempt VS Non-Exempt. This is the source sheet: https://app.smartsheet.com/b/publish?EQBCT=2b4a116ae47c4d17a13c6fea0d751347 Sheet I wanted the Vlookup results- for: Exempt:…