I am looking for a formula that will place a number in column B if Column A has a check box that is checked.
Thanks in advance.
=IF([Column A Title]23 = 1, 3000)
Put this formula in Column B and replace Column A Title with the actual column name. And change the row 23 - to whatever row number it is. Then change the number 3000 to whatever number you want.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Good Afternoon All, Currently having trouble with an index collect formula between 2 SmartSheets. On Sheet A there are 50 Unique ID's that correspond to 50 Creative Names on Sheet A. On Sheet B I am trying to bring those 50 unique Id's over by matching back to the 50 Creative Names on Sheet A. So my formula is as such:…
I am running in circles trying to solve this issue - seemingly, in using MATCH() on an external cell reference, the value it returns caps itself at 14 even though data goes out to ~30. While I end up using this base function in much larger equations, the screenshots explain the basis of the issue: Here is the Cell…
I am working on a rubric that faculty can score for microcredential awards. There are 5 scoring criteria, then a column for "total" score, and then a "yes"/"no" dropdown for "Meets credential requirements." I've set up the total score to only show if none of the criteria columns are blank: =IF(COUNTIF([Project Approved…
©2024. All Rights Reserved Smartsheet Inc.