Hello Everyone,
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.
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
