-
Formula to get multiple choice form question onto dashboard
Smartsheet Newbie here and I'm having trouble figuring out a formula that works with the multiple choice answers on the form I created. I want to put the answers onto my dashboard in a bar graph and have created a roll up data sheet. I have the single answers questions up there but I can't figure out the multiple answers.…
-
IF, OR, AND Functions
Looking to see if anyone can assist me with this formula. The formula works in Excel but not in Smartsheet, I'm getting an #incorrect argument set. =IF(OR(AND([Tier Achieved(Target Validation)]@row = "Platinum", [2021 Tier Achieved]@row = "Silver")), AND([Tier Achieved(Target Validation)]@row = "Gold", [2021 Tier…
-
Using a range of checkboxes for an IF statement
Hi, I have a column of checkboxes, and next to them are cells with just regular text. I want the text to be referenced in another sheet only if the checkbox is checked: I can get it to work for just one value fine with =IF({checkbox reference}, {personal goal reference}), however this is just one pair of cells and I would…
-
Dates in a column
I want to write a formula where when I put in a start date in the first row, the next row in the same column will add a certain number of days and fill in that next date. I know this is something you can do in the rows, but I would like to do this in a column. Any suggestions on how this can be accomplished? Kind regards,…
-
TotalFloat inconsistency between parent and child tasks
I am looking to utilize TotalFloat in a project plan and am finding inconsistent results with parent and children tasks. The sheet is set to Mon-Fri working days with no holidays set. The formula in use is =TOTALFLOAT([Task Name]@row) + " days" From what I am seeing: -The manually calculated delta between Line 14 and Line…
-
Reference Sheet Issue with formula - UNPARSEABLE
=COUNTIFS({ANOTHER SHEET Range 2} = "2022", {ANOTHER SHEET Range 3} = "1" ANOTHER SHEET Range 1}, "One person")
-
Averaging Over Date Range
Hello, I'm attempting to create a monthly scorecard based on an average completion %. The first picture conveys the completion % for that inspection based on inspection form entries, however I need to average that score over the month. To avoid an extensive formula, I was able to create a formula to count the first part of…
-
Countifs
Hi, I have been searching the boards and am not coming up with what I want so I am hoping someone can point me in the right direction. I have a sheet with a multi-select column. In the column you can select: A B A, B I want to find the 3 formulas that will count the number of times A shows up by itself, the number of times…
-
COUNTIF with multiple criteria
Hi, I am trying to create a function to count the number of times we got a certain response, i.e. "very poor" separately based on which stage of studies a student is on (separate column). So I want my countif to pull from 2 columns (educaitonal materials and step). Here is the formula I made, but I keep getting an error.…
-
SUMIFS and NOT
Hello, I'm receiving an error in the below formula. Not sure if I'm using the "NOT" correctly here. I want to sum all the story points for all "Small" projects, but exclude projects where the phase is in "Backlog" or "Pause/On-Hold." =SUMIFS({Planning Story Pts}, {Project Size}, "Small", NOT({Team Phase}, "Backlog",…