Sign in to join the conversation:
Hi All
has anyone successfully made a risk assessment template within smartsheet ?
Im not able to get normal excel formulae to work ( also the templates posted on smartsheet dont work )
appreciate if you could share template with me
Marie
Hi Marie,
Try reaching out to our Support team to see if they have a Smartsheet version of the risk assessment template. (I know sometimes they have those templates available to them.)
As a basic outline, I have column 1, 2, and 3. Columns 1 and 2 list 4 identical options: A, B, C, D in a drop down menu. Essentially, I would like column 3 to calculate/display the difference between columns 1 and 2, removing a duplicate. For example: Column 1: A, B, C, and D are selected in the drop down Column 2: B is…
I need the formula to get the text from the next row in a specified column. I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3. This is what I have tried so far but getting #unparseable error. =INDEX(Test:Test, row() , +1) =INDEX([Test]:[Test], row() ,…
I have a formula that is currently working (see below); I need to add a condition, from a specific Column (Study Status)-that if it equals a particular choice ("Study Ongoing - Follow up"), that it doesn't even bother looking at this formula and automatically turns the FLAG off. Furthermore, I'll need to have several…
